 cyberax wrote:
For performance always try to have just one recordset object open at a time. This really boosts the performance. |
Where in WWF is there ever more than one recordset open?
There is one recordset variable, rsCommon. It's only ever open once at any time.
Regards using stored procedures, I've seen this hotly debated on other forum software sites. The concensus seems to be (and being backed up by performance tests)that there is no performance gain by switching to stored procedures but they do make maintenance more painful.
I agree the pagination isn't perfect, but I can't see how else to improve it. Melkor's site shows how it can start to suffer with the members list having to pull back 80,000 records to display just 25 and this takes 3-4 seconds. Even a SP will have to initially pull off those 80,000 records before it submits the final 25 for the page. This is an extreme example though. For me and my forum, I really can't see it being an issue.
Topic Options
Post Options
Thanks(0)
