too much data

[gcohen]

hi,

I've created a survey program that has a table for respondents and a table for data, with each question being a new record in the data table and each data has a respondent_id attached to it.

I have a survey that has over 500 respondents and over 43000 data records. when a user goes to download the data though, the page times out.

does anyone have any suggestions on how I can speed this up?

thanks,
greg

[lilleman]

Maybe you can post some of your code or SQL queries? It's much easier to help if there is some code to look at.

-- lilleman