Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Bad Database Design - Is my table too large?

I have a poorly designed database. One of the most important tables has 11,000+ entries. We would like to expand our system, and I am wondering if this table grew to 5x its size, would this be a problem? It's 15360 kB in size... if that matters.


I'm using phpMyAdmin, the server is a Fedora Linux box (nothing fancy), The load is light. It stores just about everything our system uses.

like image 938
Samwise Avatar asked Nov 28 '22 02:11

Samwise


1 Answers

What DBMS? What server? What load? What application?

Besides: 11.000 records are nothing, really. Even in MS Access. :-)

EDIT: So I assume you use a fairly recent MySQL with MyISAM tables. In theory, you can go ahead and fill the table into the millions of records. Depending on how you work with them (lots of joins / or not, lots of queries/updates/deletes / or not), you don't need to do anything special. Put a proper index on the table and you should be fine.

like image 197
Tomalak Avatar answered Dec 04 '22 08:12

Tomalak