This topic is locked

Speed up result set

7/28/2006 11:41:20 AM
PHPRunner General questions
A
apensler author

I have about 4,500,000 records and I am trying to do a lookup on one field. The most a result set should be is about 73 records. It now takes about 3 minutes to get a result. Is there anything I can do to speed this up. I am using MySQL and i have the table set to MyISAM. I have the field indexed but I do not believe it is actually addressing it.
Any sugesstions???

Alexey admin 7/31/2006

Al,
PHPRunner performs case-insensitive search.

You can greatly increase the performance by switching to case-sensitive.
To do this modify generated include\dbconnection.php file.

Replace this snippet:

function db_upper($dbval)

{

return "upper(".$dbval.")";

}



with the following:

function db_upper($dbval)

{

return $dbval;

}