In my earlier post i forgot to mention about limit,10,20 to be added in
query.
- Original Message -
From: "Binay Agarwal" <[EMAIL PROTECTED]>
To: "Roger Davis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 5:22 AM
Sub
t_Search.html
Roger
> -Original Message-
> From: Binay Agarwal [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 10, 2003 7:53 PM
> To: Roger Davis; [EMAIL PROTECTED]
> Subject: Re: Quick ones to speed up acces!
>
>
> Thanks Roger for quick response.
>
> Herebel
Hi everybody!
I am querying from a table containing more than 40,000 records. Earlier when the
records were 10,000 it was taking 9 sec and now after 1 year and 40,000 records its
taking 30 sec. Code is the same.
I am pretty sure that it has something to do with database only. No body can think
; Sent: Sunday, August 10, 2003 7:08 PM
> To: [EMAIL PROTECTED]
> Subject: Quick ones to speed up acces!
>
>
> Hi everybody!
>
> I am querying from a table containing more than 40,000 records.
> Earlier when the records were 10,000 it was taking 9 sec and now
> after 1
headline like '%blah%' or cat like '%blah%'
Please help me out.
Binay
- Original Message -
From: "Roger Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 4:57 PM
Subject: RE: Quick ones to speed up acces!
> I
: Monday, August 11, 2003 5:49 PM
Subject: RE: Quick ones to speed up acces!
> MySQL does not use an index when you do "%blah%". It would use the index
> for "blah%" however. See the following reference.
>
> http://www.mysql.com/doc/en/MySQL_indexes.html
>
&g