setting up new db (SQL)

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mtm81 Members Profile Find Members Posts Groupie Joined: 03 December 2002 Status: Offline Points: 57	Post Options Post Reply Quote mtm81 Report Post Thanks(0) Quote Reply Topic: setting up new db (SQL) 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

mtm81 Members Profile Find Members Posts Groupie Joined: 03 December 2002 Status: Offline Points: 57	Post Options Post Reply Quote mtm81 Report Post Thanks(0) Quote Reply 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.

mtm81 Members Profile Find Members Posts Groupie Joined: 03 December 2002 Status: Offline Points: 57	Post Options Post Reply Quote mtm81 Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum