cmiddlebrook Posted May 18, 2011 Share Posted May 18, 2011 I have a database which currently has tens of thousands of tables and it is growing daily and I am having trouble finding a MySql client which can handle it. The problem is that most clients such as PHPMyAdmin want to try and load the entire list of tables before it will let you do anything. All I need is something that will allow me to load perhaps the first 50 tables then stop, and I can perform queries if I need to see the rest. This is becoming a real problem as I just can't load the database without it timing out or just hanging the whole computer. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted May 18, 2011 Share Posted May 18, 2011 You have a much more serious problem than finding a database management tool that can do this. You should not be creating separate tables for each new piece of information. Quote Link to comment Share on other sites More sharing options...
cmiddlebrook Posted May 18, 2011 Author Share Posted May 18, 2011 It's one table for each website member. I think that's reasonable. The choice is either thousands of tables or a truly gigantic single table. Quote Link to comment Share on other sites More sharing options...
requinix Posted May 18, 2011 Share Posted May 18, 2011 It's one table for each website member. I think that's reasonable. Not even close to reasonable. Yes: you are supposed to use one "giant" table. That how databases are supposed to work. How they're designed and engineered to work. How you're expected to use them. Don't try to second-guess the database system's optimizations by coming up with your own solutions to perceived problems (that aren't actually there). Stay on the yellow brick road and you'll get to the Emerald City just fine. Quote Link to comment Share on other sites More sharing options...
cmiddlebrook Posted May 18, 2011 Author Share Posted May 18, 2011 Okay so if I was to merge all the member records into a single member table, currently that would create a table with 2-3 million rows. Are there any limits that I would need to be aware of such as number of rows, or physical table size as this continues to scale? Quote Link to comment Share on other sites More sharing options...
fenway Posted May 18, 2011 Share Posted May 18, 2011 On a 32-bit system, 4GB -- otherwise, no. But that's billions of rows. Quote Link to comment Share on other sites More sharing options...
cmiddlebrook Posted May 18, 2011 Author Share Posted May 18, 2011 Ok thank you all. I obviously need a re-design! I've ordered a book which should help me! Quote Link to comment 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.