"Octavian Rasnita" schreef:
> CREATE TABLE `articles` (
> `id_newspapers` smallint(3) unsigned NOT NULL default '0',
> `id_sections` smallint(3) unsigned NOT NULL default '0',
> `id` int(6) unsigned NOT NULL auto_increment,
> [...]
> PRIMARY KEY (`id_newspapers`,`id_sections`,`id`),
This
If these queries work so slow, I am wondering how slow it will work when the
database will have a million records.
See fulltext docs at mysql.com, my point still was paginate and use
LIMIT (or DB's equivalent) so your perl only has to process an array of
a few records instaead of all.
IE
fo
ow, I am wondering how slow it will work when the
database will have a million records.
Thank you.
Teddy
- Original Message -
From: "JupiterHost.Net" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 01, 2006 4:37 PM
Subject: Re: faster search engine for fulltext search
&g
Perhaps doing your queries to return only some instead of all records
will help, a great module for doing this is:
http://search.cpan.org/perldoc?Data::Paginate
I am using a limit clause and the sql query returns at most 20 records, but
when very many records are found, the search is very slo
From: "JupiterHost.Net" <[EMAIL PROTECTED]>
>
> > Next, your op says "When very many records are found..." What is the
purpose
> > of your client program loading large recordsets? You should probably be
> > paging the data somehow.
>
> Perhaps doing your queries to return only some instead of all
Next, your op says "When very many records are found..." What is the purpose
of your client program loading large recordsets? You should probably be
paging the data somehow.
Perhaps doing your queries to return only some instead of all records
will help, a great module for doing this is:
h
""Octavian Rasnita"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I am using a perl program (mod_perl handler) that searches a MySQL
> database
> which has a few hundread thousands records, using a fulltext index, but it
> works pretty slow. When very many records are fo
