Problem from getting data from dbf file (Maximum execution time of 30

[samansk]

I have old data from another department store in dbf format
(about 200000 reccords) when I retrive data from this file it error like this "Fatal error: Maximum execution time of 30 seconds exceeded " I have test this php script it work fine with 100 records . This is php code in my script
.........
........
$fp = dbase_open($dbname,0);
}
if($textfield){
$key=$textfield;
$nr = dbase_numrecords($fp);
$i=0;
for ($i=1; $i <= $nr; $i++) {

$temp = dbase_get_record($fp,$i); <==== This line make error

if (chop($temp[1]) == $key ) {
$sc=getname($temp[0]);
.........
.......

How to set the php executable time more than 30 seconds or how to solve this problem.

Thanks.

 

[samansk]

when I use set_time_lomit(0) function it work but have
duplicate rows in one key( for search) How to correct this problem.

 

[SteveBrett]

the maximum execution time for a query can be increased by changing the value in the php.ini file (usr/local/lib/php.ini - assuming you're running linux).

 

[SteveBrett]

the max time for query execution can be changed in php.ini (normally found in /usr/local/lib/php.ini)

 

[tkrabec]

Optimize the database, I have the same problem in one of my postgresql databases, when I try to do a very generic search it returns too many records and it times out on the web interface
-- Tim