I will post a beta 3 SQL server 2000 version in a few days. For those who e-mailed me regarding SQL server support, please come download in a few days. Beta 2 is fully compatible with SQL server 2000.
In a preliminary test I carried out today, beta 3 SQL version is very capable of paging even 100,000+ records in individual forums (celeron 550 o/c to 800, 256MB RAM, SQL 2000 Evaluation Edition, Windows 2000 Professional w/ sp2). This BEATS almost all forums available to date. I can' t say ALL forums because I haven' t had a chance to check out ALL forums available on the market because some are just too expensive.
For a threaded forum, ASP Playground is unbeatable performance-wise. I am still trying to figure out the theoretical limit of my current algorithm/stored procedure combo within a reasonable data range. In the next version (version 1.0 probably), I will implement a new paging technique to even increase the speed by 2-3X with SQL server 2000.
I am having a lot of fun tweaking all aspects of paging in my spare time (and not doing anything productive ><)!!
_____________________________
Forum Administrator
Samuel Chou
ASPPlayground.NET
http://www.sam-alice.com
< Message edited by Admin on 8/8/2001 5:06:58 PM >