Browser(IE) time limit in PHP/SQL

[ondoy]

---

Hi All,

Can someone please help me with my problem,
Naa ko e retrieve nga more than 400,000 records sa database, problem is ga time out ang browser both IE & Firefox. I have fixed this issue on Firefox, gi increase nko ang max time out to (120).Ni display ra, pero ang IE(7.0) ga "cannot display" man.
It would take almost 3 minutes to retrieve the data using Firefox.

basic ra ako query, 1 ka column ra e retrieve but daghan ug result.
query = select column from table.

Naa mo idea kung unsaon ni?. Gae lngko idea and i do the rest..

Tnx,

DoyOn

[cen]

Gamiti na og paging bai.
http://www.php-mysql-tutorial.com/php-mysql-paging.php

[ondoy]

Salamat sa tabang bai, pero dili man puede e paging gud...gaan tka idea sa project ha..

Nkoy 2 table:
table 1:= age bracket ni (18-25,26-35 ....) 6 rows rani 1 column.
table 2:= records nga gi abot na ug almost 500,000 unya murag more or less 50 ka columns.ka limot nko hehehe

naay option nga mag select ka ug edad din, kna cya e query na nya sa table 2 kung unsa halimbawa score ana nga edad then karon 1 column pa nko ang gi gamit sa table 2. ANg result dayon ana, himuon ug statistics (Mean,Mode,Median...). Naa pgyud option nga mag select ka ug daghan nga age bracket but not all.
Kini cya na project ga dagan ni sa lahi nga set of database, same format sa table but gamay ra ug data less than 50,000 rman cguro ka records toa. Ang Firefox mka dagan ug isa ra ka option but kung 2 na wla na blangko iya gawas. Mao ni kadtong gi tasan nko ug time_limit.
Ang IE wla gyud intawon ka antos, error jud dritsu..Ka dungog ko anang stored procedure, prob is diko balo unsaon. Basin nkay idea...Basa napud hehe
Ang out diay ani niya kadto rand Mode, Median, Mean ug Standard Deviation..Long process few output hehe

Basin namoy idea, tabang intawon

[vern]

How much data are you retrieving from your query? Do you really need to get all that data at once? Sounds like you needed better queries.

[silent-kill]

naa ta kai statistics table gi himo daan bai for each tester. hmmm.. para di naka sigi select did2 sa imong main records nga 500,000 ka book.
dili ma dala index bai? ehehe

[ondoy]

salamat sa tabang, i have to find ways to optimized my query.i think naa judni sa query unsaon..i'll post nlng diri kung ma sulbad na, basin naay mka encounter ani nga prob aron mka tabang...tnx

[M@rv|n]

hmmmm .... wild question lang ha
1. na try nimo ang increase ang timeout sa imong apache?
2. na try nimo query using a query analyzer? if maka return ba jud cya tarong?
3. na try nimo gamit ug limit?(paging gihapon)

[romano2717]

Gamiti na og paging bai.
http://www.php-mysql-tutorial.com/php-mysql-paging.php

sakto jd ni oh! pag paging nlng.. tunga-tunga ang results na e return pra di ma boang ang browser og fetch sa data asa ka anang 400,000 records?! woohh!

[cold_fusion]

set_time_limit(xxx_seconds)
or max_execution_time in php.ini

This is NOT advisable though.
Use paging instead or AJAX and retrieve rest of data during page downs/ups.

[cold_fusion]

Another solution without modifying the set_time_limit(), is to use AJAX + javascript timer.

First, show the result template (without the result yet).
Then with a javascript timer after xx seconds, retrieve the result stored in a temporary table via AJAX.
Then display it by modifying innerHTML of the div tag of the result template.