This actually applies to the current release also. I've been studying the SQL code that is generated by the application and it's effect on MS SQL Server. It appears that the forum.asp code is generating a significant number of table scans. The Active Topics page does the same type of query.
Can we add an index to FORUM_TOPICS composed of T_LAST_POST and FORUM_ID? I'd also like to suggest converting the date fields from varchar(50) to char(14). Even with the fields being varchar the indexes improves performance. Converting the fields should improver performance even more.
Another index that will help is on FORUM_MEMBERS on M_NAME. This will improve the login performance.
<font color=blue><b>SQLTeam.com</font id=blue></b> - For SQL Server Developers and Administrators
About the indexes: could you take a overall look at them and see if there also are (maybe) onces that are not needed.
You can find them in inc_create_forum.asp in Version 3.1 Beta 2 or newer. Those are the ones used by the setup script.
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0> <font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple>
Ok, I've started work on this but I'm putting each suggestion in it's own topic. Some are easy and some are hard and I wanted each to be evaluated independantly. Check this forum for each suggestion.
<font color=blue><b>SQLTeam.com</font id=blue></b> - For SQL Server Developers and Administrators
Thanks ! <img src=icon_smile_approve.gif border=0 align=middle> I'll look at each one and post remarks.... (might be many "changed in source" remarks).
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0> <font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple>
Topic Locked
Posted - 06 September 2000 : 23:18:12
