ong. You might as well be searching on LIKE "%.mp3%", probably would be about just as fast, and you could use a memory
table if you wanted.
- Original Message -
From: "Svilen Spasov (Ancient Media)" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 13, 2006 9:57 AM
Su
Thanks for your respond.
Here is the CREATE TABLE:
CREATE TABLE `results_1` (
`id` int(11) NOT NULL auto_increment,
`filename` varchar(255) collate cp1251_bulgarian_ci default NULL,
`fileext` varchar(10) collate cp1251_bulgarian_ci default NULL,
`username` varchar(16) collate cp1251_bulg
Svilen Spasov (Ancient Media) wrote:
Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty m
Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty much. It always stays on
20 load av
