acctman Posted April 27, 2009 Share Posted April 27, 2009 would i gain any noticable performance by using multiple databases? example would be a database that holds country, city, and zip code info. then the main user database. Quote Link to comment https://forums.phpfreaks.com/topic/155777-multiple-dbs-or-just-one/ Share on other sites More sharing options...
dreamwest Posted April 27, 2009 Share Posted April 27, 2009 If your after speed - Whatever you gain would be lost connecting to multiple databases Unless you have millions of queries an hour i wouldnt worry about it. Your better of caching content and compressing data to reduce server load: #increase speed and preserve bandwidth <ifmodule mod_php4.c> php_value zlib.output_compression 16386 </ifmodule> # 1 WEEK <FilesMatch "\.(jpg|jpeg|gif|ico|png)$"> Header set Cache-Control "max-age=604800, public" </FilesMatch> # 5 MIN <FilesMatch "\.(css|js|swf|flv)$"> Header set Cache-Control "max-age=172800, private, proxy-revalidate" </FilesMatch> Quote Link to comment https://forums.phpfreaks.com/topic/155777-multiple-dbs-or-just-one/#findComment-820077 Share on other sites More sharing options...
Mchl Posted April 27, 2009 Share Posted April 27, 2009 If these databases resided on single database server you would gain nothing. Quote Link to comment https://forums.phpfreaks.com/topic/155777-multiple-dbs-or-just-one/#findComment-820100 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.