Login to Account Create an Account
1 Database or 2?
Posted 23 January 2007 - 01:15 AM
by diffrence i mean performance diffrence.
Posted 06 March 2007 - 11:10 PM
Contribute: [Sponsorship] [Affiliation]
Resources: [Member Projects] [Guides] [Tips & Tweaks] [Workstation 2003] [Hosting]
Bookmarks: [HFSLIP] [MSFN Codecs] [Glent's Tweaks] [a06lp's Drivers] [Networking]
Posted 13 March 2007 - 09:08 PM
im not exactly sure if you would notice the performance increase tho, unless your working with millions of entries.
i was just thinking about this, seriously like an hour ago, and i just decided to put it all in 1 database. only reason was b/c of organization. say the server where you were going to have the database already has like 20 databases on it... i use phpmyadmin alot, just for testing right now, hopefully i wont ever have to use it later on besides from having to manually edit/delete something for some reason.
Desktop: || lappped Q6700 w/ lapped TRUE || ASUS P5Q Deluxe|| Sapphire 4870 1GB || Mushkin Ascent XP2-8500 (2x2GB) || 2 x WD6400AAKS || Corsair HX620W || Lian-Li PC-60FB || 2 x BenQ G2400WD || Vista Ultimate 64bit || Samsung SH-S223Q || Logitech MX518 || Logitech Ultra-X || SteelSeries SX || Klipsch ProMedia Ultra 5.1 || ATI TV Wonder 650 PCIe ||
Server: || E5200 w/ XIGMATEK HDT-S1283 || ASUS P5Q-EM || EVGA 8800GTS G92 w/ Accelero S1 R2 || G.SKILL 6400 2x2GB || 1 x WD6400AAKS || 4 x 1TB Samsung F1 || SeaSonic M12II SS-500GM || Antec Three Hundred || Samsung SH-203BL || Ubuntu 8.10 ||
Posted 13 March 2007 - 09:14 PM
Posted 19 April 2007 - 09:21 PM
than use the prefix
but if you got more than one database than use a database for each one
so its quicker to backup / restore / to use
Posted 20 April 2007 - 03:44 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users