Hello Pushpinder, Thursday, December 4, 2003, 4:38:13 PM, you wrote:
PSG> I want to be able to create a similar CRM package for other clients. My PSG> question is should I create a separate DB for each client. PSG> or is it a better design practice to create 2 tables (Admin and PSG> Contacts) per client within the same DB. I am not sure if I have been PSG> able to clearly express my doubts here, but I will be more that happy PSG> to address any questions. It's really a numbers game. If you are likely to need to create hundreds (or thousands) of new databases then it's not the most efficient way to do it. If on the other hand you'll only never need to make a few, then it's probably simpler to do this than restructure the existing tables. That way you can back-up a clients database, or deny them access to it, easily and without effecting the others. -- Best regards, Richard mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
