Bad database design. Am I too big a table?

Question

I have a poorly designed database. One of the most important tables contains 11,000 entries. We would like to expand our system, and I wonder if this table has grown to 5 times its size, would it be a problem? It has a size of 15360 kB ... if that matters.

---

I am using phpMyAdmin, the server is a Fedora Linux block (nothing unusual). The load is light. It stores almost everything that our system uses.

Answer 1

I understand that you are concerned that increasing the number of records to 55,000 in "your poorly designed database" will affect performance.

, , , 50 000 , .

50k , , .

, , , .

Answer 2

? ? ? ?

: 11.000 , . MS Access.: -)

EDIT: , MySQL MyISAM. . , ( , /// ), . , .

Answer 3

, , - . ? ? ? ? ? , ?

Answer 4

11k . 50K .

( , ) , , .

, .

Answer 5

" "?

, , .

, 11000 . 15 db.

Answer 6

. , , , . , ; , .

, , , () , . , (-, , ..).

Answer 7

15MB . 11k . 2 + , 1 , , - .

Answer 8

, , . ? 876 ? Col1, Col2, Col3...? float datetime ? ? , , .

Answer 9

11K .

, ?

Answer 10

.

, 15 000 , , .

Answer 11

. , , . , . , , , .

Answer 12

SQL Server 2005, SQL Server .

, .

Answer 13

, , , .

, , . .

Answer 14

, , . , 11 000 , 10 . , , , . ( ). struture, , .

Perhaps the problem is that you and your colleagues simply do not have access to the database and do not know how to query them efficiently and easily. Or the problem may be that the design is bad, without structural details, it’s hard to say.