FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Any limit in creating no: of tables inside one database





firumon
Is there any limit of creating the number of databases inside one database...
Many of the free hosting websites only provide limited number of databases...
Some of them give only one... So if there is no limit in creating the number of database, one database is enough..
sonam
Acually yes, you can insert lot of tables in one database, but if you have few sites it is better to have datas in different databases because it is easier to handle it, especialy if you have lot of tables. The second reason is security. For example, if someone hack your database in site "A" then yours database in site "B" is secure. If you have only different tables in one database then hacker have all your sites in his hand.

Sonam
rvec
and frihost doesn't limit it, you can create as many databases as you want.
kv
I agree with sonam. Also there can be reduction in performance as number of tables increase in a database.
swizzy
rvec wrote:
and frihost doesn't limit it, you can create as many databases as you want.


and even if some other evil host restricts the number of databases, you can use prefixes for various scripts to rule out conflicts, and maintain multiple scripts on your host.
Related topics
Mysql database problem
Create Usernames: User Account to DB vs. TABLES vs. CELL
A very good PHP MySQL Tutorial
Somebody using my database ?
Creating something?
a site where i can learn mysql syntax
phpBB - Installation Tutorial
Creating a new phpbb forum on my new domain.
PHP Script Needed for 250 frih$
Why don't people like tables?
PHPBB3 HOW DO I ENTER THINGS IN TO THE DATABASE SETTINGS
Connection to DB
Creating tables with Mysql queries
What is the Limit of Tables in a SQL Database ?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.