Web Wiz Forums - setting up new db (SQL)

Print Page | Close Window

setting up new db (SQL)

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20570
Printed Date: 11 April 2026 at 1:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: setting up new db (SQL)

Posted By: mtm81
Subject: setting up new db (SQL)
Date Posted: 06 July 2006 at 12:50pm

Hi,

When setting up a new forum using SQL.. instead of creating a new db, I was going to us a db with existing tbls for other purposes that do other things around the site.

1) - Would this affect the performance of the forum (i.e does it prefer to be running in it's own db)

2) - When I create the db I don't want it overwriting any existing data... The only way I can think this would happen would be if there were any existing tbls called the same as the new ones created for the forum..

How can I check this.. is there a list ofthe tbls created for the forum I can check against?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 July 2006 at 2:50pm

A new database is best and would give better performance, but you can use an existing one if you prefer.

All tables in web wiz forums begin with the table prefix 'tbl' if you feel this will course problems with your own tables in the database you can change the table prefix in the file 'includes/setup_options.asp' just edit the file with notepad.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mtm81
Date Posted: 06 July 2006 at 3:12pm

ok smashing - one last thing.. if I'm planning on using the existing member api system and these members are a part of this existing db - would I NEED to use the same DB or is it independant.

Posted By: mtm81
Date Posted: 06 July 2006 at 3:53pm

oh one other thing...

the forum is in a logged in only progrected area.. if a user tries to access any other area of this protected area, a piece of code in the top of each page written in ASP, checks the session and if it doesn't exist, boots them to the login page...

How does this work in conjunction with the forum...

Is there a particular include (like the common.asp) one for example which is on every forum page and therefore if I posted my piece of code in there would force this to work?

Posted By: WebWiz-Bruce
Date Posted: 06 July 2006 at 3:58pm

If you use the member API your database runs independently from that used in the forum.

The common.asp file is used on every page, but remember when adding your own code to this to declare all new variables as strict coding is enabled within the forum code.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting