Welcome Guest, Not a member yet? Register   Sign In
Best way??? - many user/db-tables -> using different db for every client?
#1

[eluser]Jan_1[/eluser]
Hello!

additionally to my standard tables (Auth, client data, and other central stuff) I need 20 tables per client. So, if I might be lucky and have some thousand clients (I know, but let me dream...) it would get difficulty using table_prefix in just one database. Would'nt it?
Also might it be cool to separate the different clients data (so the 20 tables), because these would be more or less discrete company data.

So, I thought it would be good to use one central database and one database for every client. Codeigniter has a way to use different databases.

A) How do I make the second (main) database-connection dynamic? Writing a library that for? The data are in my central database tables.

B) How to I handle with performance. I have tried to work with 2 database connections and it is really slow on localhost.

C) What's usually the right way? If I would not do it this way and would use db-table-prefixes: How many database tables and table lines could I put in one MySQL database?

Every hint or comment appreciated!
Thanks!!! Jan


Messages In This Thread
Best way??? - many user/db-tables -> using different db for every client? - by El Forum - 02-10-2013, 07:11 AM



Theme © iAndrew 2016 - Forum software by © MyBB