Database creation 
Author: Sam S.
Visited 1795,
Followers 1,
Shared 0
Hello,
1. Is it necessary to create a database for each feature as in one for guestbook, blog, ecommerce, etc?
2. Are there any pros and cons for just using one database only with different tables compared to multiple databases?
3. Why was it mandatory to name a table in database creation when in the Help instructions it said that "if no table is named, it will automatically create one"?
Thanks,
Sam
Posted on the
Hello Sam,
In response to your queries:
1. You can use the same database if you wish (i.e. a single database) and just separate your data into different tables as required.
2. This is down to personal preference really. However, you could argue that it would be a pro to have only one database as there would be fewer connections required to perform queries, therefore enhancing performance. Many webhosts limit the number of MySQL databases supplied with their hosting packages, so using fewer databases would again be an advantage. However, on the flip side you could argue that data security is enhanced by using discreet databases with unique passwords, etc.
3. You are misquoting slightly from the help file, I think? Can you point me to the location of that text in the help file? The text I have is as follows:
Table Name: enter the name of the table in the database where you want submitted data to be added. If the table doesn't exist, it will be created automatically
There is no contradiction here... this simply means that you don't need to go to the trouble of creating a Table first using something like phpMyAdmin... instead WebSite X5 will automatically create a Table with your name of choice, if it doesn't exist already.
Kind regards,
Paul
Author
Hello Paul,
Thanks for your quick response and your answers to 1 & 2. Also thanks for informing me about some webhosts who limit the number of databases you can create. This would now factor in some decisions being made.
About #3, thanks for elaborating. This was in Guestbook Object creation. FYI this is what I was thinking: I was paraphrasing what I understood the Help said; that if I do not name the table, WX5 would automatically create a table name and table for you. It was the 2nd sentence: If the table doesn't exist, it will be created automatically, that threw me off.
Because thinking that for each additional Guestbook Object created for different purposes, blog, or ecommerce, a new table is necessary. So why would I link this new Guestbook being created to an existing Guestbook table, etc?
BTW, in some areas when you click Help, it does not pop up. ie:Dynamic content. Cannot remember now which ones but I thought there were others. Perhaps, this is the only one.
Thanks again,
Sam