phpretard Posted March 29, 2008 Share Posted March 29, 2008 I plan on importing 3-5 thousand entries at once (all is text). Each entry has 20 pieces of information. (ie. name, address, phone, and so on...) I will input these once per week. How much information is too much for one DB. Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/ Share on other sites More sharing options...
MadTechie Posted March 29, 2008 Share Posted March 29, 2008 Depends on the size of your harddrive.. Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503703 Share on other sites More sharing options...
phpretard Posted March 29, 2008 Author Share Posted March 29, 2008 It is actually a godaddy hosted site. Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503711 Share on other sites More sharing options...
MadTechie Posted March 29, 2008 Share Posted March 29, 2008 Okay.. depends on the allocated space.. you can put as much data in until the drive it full! Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503712 Share on other sites More sharing options...
phpretard Posted March 29, 2008 Author Share Posted March 29, 2008 10-4 Will this affect the speed of the site? Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503717 Share on other sites More sharing options...
MadTechie Posted March 29, 2008 Share Posted March 29, 2008 Not if the site doesn't use the database, if it does use the database it depends on the design and use.. very hard to say but yes more data slows it down, (badly if it has a bad design) Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503720 Share on other sites More sharing options...
phpretard Posted March 29, 2008 Author Share Posted March 29, 2008 Thank you very much for your advice... Any more thought would be appriciated! -Ant Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503723 Share on other sites More sharing options...
MadTechie Posted March 29, 2008 Share Posted March 29, 2008 Okay.. simple table 20 fields (with a unique ID) 20000000 records your ID is index'd and an autonumber primary field.. you search/link only by ID, not a problem Now lets say you have a 8 inner join linking unindex'd fields using a select in a select.. probably going to get a timeout.. okay if they were index'd 8 joins (or even the select in a select by itself) may of killed it anyways but you get the point Quote Link to comment https://forums.phpfreaks.com/topic/98426-database-overload/#findComment-503726 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.