It appears that 2 1/2 pages of the 17 pages I printed for inc_create_forum.asp went to create default values for the CONFIG table. I'm pretty sure there can be only one record in this table. A little further down, one record is inserted in this table. Any chance we could move those defaults into the insert statement? Maybe an insert and a series of updates? It just seems we are creating lots of defaults that are only used once.
<font color=blue><b>SQLTeam.com</font id=blue></b> - For SQL Server Developers and Administrators
Does having defaults make it slower ? I created the original inc_create_forum.asp based on the sql-script that someone supplied for SQl-server. For the MySql setup-script I combined the defaults with the create-table statement so there I didn't have the 2 1/2 page extra but did have the defaults.
I could move those for SQL-server into the create tables also, that would increase the readabilaty of the page. If it doesn't slow the database-performance down considerably I prefer having defaults. The length of the inc_create_forum.asp isn't a real issue, because it only runs once.
<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>
BTW, as a general remark: thank you very much for all the index/database related posts. <img src=icon_smile.gif border=0 align=middle> Step one for me was to get an easy and stable install-procedure, for step two, optimizing it, this kind of help is vital <img src=icon_smile_approve.gif border=0 align=middle>
<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>