---
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
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
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
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
HP.
If you get an error, post it on the list.
-Micah
On Tuesday 19 August 2003 2:59 am, Ignatius Reilly wrote:
>
> - Original Message -
> From: "Dillon, John" <[EMAIL PROTECTED]>
> To: "PHP-DB List" <[EMAIL PROTECTED]>
- 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
I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in
another.. I think the queries are failing due to timeout on the server.
The server is not dedicated to me and I may not be able to affect the
timeout settings...though I'll ask my hosting company (Positive Internet).
If I