RE: [PHP-DB] Queries probably timing out

2003-08-20 Thread Dillon, John
--- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: 19 August 2003 20:32 To: PHP-DB List Subject: Re: [PHP-DB] Queries probably timing out IF it's a linux server apparently there's a glibc problem from a while back that causes this. Check to see if it's a redhat server. If th

Re: [PHP-DB] Queries probably timing out

2003-08-20 Thread Director General: NEFACOMP
I upgraded my server to RedHat 9 and the problem was solved. Thanks Emery - Original Message - From: "Micah Stevens" <[EMAIL PROTECTED]> To: "PHP-DB List" <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 2003 22:32 Subject: Re: [PHP-DB] Queries probably timin

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Micah Stevens
ta2.USD FROM > TestData1 INNER JOIN TestData2 ON > CONCAT(TestData1.Journal,TestData1.Description)=CONCAT(TestData2.journal,Te >s tData2.description) WHERE TestData1.Dept<>'D1'"; > > Thanks, > John > > -----Original Message----- > From: Micah Stevens [mai

RE: [PHP-DB] Queries probably timing out

2003-08-19 Thread Dillon, John
ROTECTED] Sent: 19 August 2003 18:00 To: PHP-DB List Subject: Re: [PHP-DB] Queries probably timing out What leads you to believe that it's a query timeout? Is the php script timing out waiting for the database? Do you get an error saying something about "Max Execution Time"? If

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Micah Stevens
What leads you to believe that it's a query timeout? Is the php script timing out waiting for the database? Do you get an error saying something about "Max Execution Time"? If so, you may want to set that higher in your script. Go check out: http://si.php.net/manual/en/function.set-time-limit.

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Ignatius Reilly
- Original Message - From: "Dillon, John" <[EMAIL PROTECTED]> To: "PHP-DB List" <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 2003 11:47 AM Subject: [PHP-DB] Queries probably timing out I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in a