Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Defaults on tables
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

grazman
Junior Member

USA
193 Posts

Posted - 09 September 2000 :  12:07:49  Show Profile  Visit grazman's Homepage
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

gor
Retired Admin

Netherlands
5511 Posts

Posted - 09 September 2000 :  16:19:52  Show Profile  Visit gor's Homepage
grazman,

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>
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 09 September 2000 :  16:23:05  Show Profile  Visit gor's Homepage
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>
Go to Top of Page

grazman
Junior Member

USA
193 Posts

Posted - 09 September 2000 :  20:47:45  Show Profile  Visit grazman's Homepage
The defaults should not affect the performance of the database at all. Totally agree on the get it stable and make it better approach.

<font color=blue><b>SQLTeam.com</font id=blue></b> - For SQL Server Developers and Administrators
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.47 seconds. Powered By: Snitz Forums 2000 Version 3.4.07