I have a problem with (I think) browser timing out.
I have an application that runs queries on a MySQL DB. It completes all the
queries according to my MySQL log but about 2.5 min into the application the
browser says done and does not post the rest of the data. Meanwhile the
queries
are still running.
Any Ideas on what to start looking for .
log results:
020416 20:01:23 2 Connect [EMAIL PROTECTED] on
2 Init DB NewReportingTool
2 Query SET SQL_BIG_TABLES=1
2 Query SET SQL_BIG_SELECTS=1
020416 20:01:24 2 Query SELECT sum(count) FROM
OffersV3_access_log Where date BETWEEN '2002-01-01' AND '2002-01-07'AND
time BETWEEN '00' AND '23'
020416 20:01:28 2 Query SELECT sum(count), type FROM
OffersV3_access_log Where (url = '/' OR url like '/index%') AND date BETWEEN
'2002-01-01' AND '2002-01-07'AND time BETWEEN '00' AND '23
' GROUP BY 2
2 Query Select sum(count), type FROM
OffersV3_access_log Where date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' GROUP BY 2
020416 20:01:38 2 Query SELECT count(*), type FROM
OffersV3_access_log WHERE referer = '-' AND date BETWEEN '2002-01-01' AND
'2002-01-07' AND time BETWEEN '00' AND '23' GROUP BY 2
020416 20:01:44 2 Query SELECT sum(count), type FROM
OffersV3_access_log WHERE status < 400 AND date BETWEEN '2002-01-01' AND
'2002-01-07' AND time BETWEEN '00' AND '23' GROUP BY 2
020416 20:01:53 2 Query SELECT sum(count),url, status FROM
OffersV3_access_log WHERE status >= 400 AND date BETWEEN '2002-01-01' AND
'2002-01-07' AND time BETWEEN '00' AND '23' group BY 2
ORDER BY 1 DESC LIMIT 20
020416 20:02:07 2 Query SELECT count(user),
user_list.callcenter_City FROM OffersV3_access_log , user_list WHERE
OffersV3_access_log.user <> '-' AND OffersV3_access_log.user = user_list.u
name AND date BETWEEN '2002-01-01' AND '2002-01-07' AND time BETWEEN '00'
AND '23' group BY 2 order by 1 DESC
020416 20:02:11 2 Query SELECT sum(count), agent FROM
OffersV3_access_log WHERE date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' group BY 2
BROWSER STOPS HERE!!
020416 20:02:21 2 Query Select sum(count), url FROM
OffersV3_access_log Where date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' group BY 2 ORDER BY 1 DESC LIMIT 10
020416 20:02:57 2 Query Select sum(count), url FROM
OffersV3_access_log Where date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' group BY 2 ORDER BY 1 ASC LIMIT 10
020416 20:03:33 2 Query SELECT time, sum(count) FROM
OffersV3_access_log WHERE date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' group BY 1 order by 1
020416 20:03:43 2 Query SELECT date, sum(count) FROM
OffersV3_access_log WHERE date BETWEEN '2002-01-01' AND '2002-01-07' AND
time BETWEEN '00' AND '23' group BY 1 order by 1
Thanks
jb
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
