[UCCASS] UCCASS - problems rendering table results with large amounts of data

[Paul Parker]

The organisation I work for [ www.engelska.se ] has been using UCCASS  
on a trial basis for a few months now and have found it to be very  
useful. We have had a couple of problems when dealing with large  
amounts of data. With our fourth and most recent survey we have  
received an average of 1600 replies per question. The problem that  
has arisen here is that the results table view will no longer render.  
The browser connection simply dies every time. The only browser that  
gives me a response, and not just a blank page, is Safari (The error  
was: “lost network connection”). I suspect however that the problem  
doesn't lie with the browsers but somewhere between our MySQL  
database, the server setup, and the UCCASS app. (All of which is on a  
remote server.)

I have tried:
	• changing the connection duration time in the  
special_results.class.php file (Line 30) but this produced no results.
	• removing code from the template results_table.tpl so that no  
answers at all would displayed - still no results at all rather than  
page with questions only.
	• exporting the complete database and importing into a local server.  
In this case I get only the questions and no answers when rendering  
table view in this survey. This could be well due to the local mysql  
setup and I will need to do further work before counting this out.)

REQUEST: What we need is some way to limit the call to the database  
so that a results table is displayed but with perhaps 50 rows per  
page instead of ALL rows (1600) all at once. This may then reduce the  
stress on the connection between the app/webserver/database. This  
would mean probably a few extra lines of code in the classes files  
(lines 33 -134 in special_results.class.php I would guess?), which  
would then change the way the tables are rendered.

Is this something anyone on this list could help us with? We would be  
happy to discuss payment terms with you. If you have answers or are  
interesting in helping please email me at
[ paul dot parker at engelska dot se ]