The number of row per table is quite low, i think it won't exceed 500-1000/table. But I may sometimes have to search into dna sequences (around 5000 atcg characters in any order), so that is quite heavy. Maybe for that field a fulltext index would be helpful?
Thanks for your help, Melanie
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: search through one/several tables Date: Wed, 23 Mar 2005 10:44:53 +0000
"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> Hi list, > > I would like to search for something into one or several tables. > My first idea was to retrieve the tables' names, then for each of them > retrieve the columns' name and have a look in each of this column. > Is there a more elegant (fast) way to do that with mysql? > > Somebody has some tips/doc where I could look for search engines?My problem > is that I don't have one big table with all the data but several little ones > with few fields, so I don't think solutions like Lucene could work.
If your tables are all identical, which it sounds like, you want to create a Merge Table: see http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
