QUERYING LARGE AMOUNTS OF DATA

[kingjjx]

Hi, Is ColdFusion capable of querying large amounts of data in a database / table ? I am trying to query from 2 tables and each table contains about 4,000 records (about 8,000 records all in all) and my CF Server just goes nuts .. it just times out after a long time ...

anybody kinda enough to share their thoughts ??

 

[tleish]

Try to set the page timeout to be longer

queryfile.cfm?RequestTimeout=6000 - tleish

 

[twist]

hmm the cf pages i've been working on lately query a db with 45k+ records regularly and rarley times out.
if your looping through your query results and querying again it can get a bit slow once you get up around 2000-3000 records. best thing you can do is try and join your queries together and only hit the db once.

 

[webron]

Are you trying to display the queries on screen?

That might be the problem. I think CF could easily query a db with 8.000 records, it's just the displaying of the data that takes a lot of time.


You might test this by displaying the recordcount of your queries.
<cfoutput>#queryname.recordcount#</cfoutput>

webron