well, you'd still have to use limit and offset with your search table
would you store a different table for each unique query? That sounds
like a lot of [temporary?] tables.
are you doing ore than 3-4 table joins on ths one fulltext search
query? If not, it's probably more work.
If your q
Hi Sheeri:
Yes, you are misunderstanding my question. I certainly know how to limit
my resultset to certain rows. I'm asking more about the effiencency of
searching large volumes of data. Is making a search table like vBulletin
does a good mechanism to avoid resource contention on the main tabl
Sounds like you want LIMIT and OFFSET --
everything after my name and before your post is copied from the doc at
http://dev.mysql.com/doc/refman/4.1/en/select.html
(or am I misunderstanding your question?)
-Sheeri
The LIMIT clause can be used to constrain the number of rows returned
by the SEL
All:
I am developing a search engine and using MySQL as the backend database
management system. Under normal circumstances, when users search through
large volumes of records on a search engine site, the results are broken
down into pages. When a user clicks on the 'Next' link, the system will
r