How many rows in a database are TOO MANY?

by

I’ve a MySQL InnoDB table with 1000000 registers. Is this too much?

No, 1,000,000 rows (AKA records) is not too much for a database.

I ask because I noticed that some queries (for example, getting the last register of a table) are slower (seconds) in the table with 1 million registers than in one with 100.

There’s a lot to account for in that statement. The usual suspects are:

  1. Poorly written query
  2. Not using a primary key, assuming one even exists on the table
  3. Poorly designed data model (table structure)
  4. Lack of indexes

More Related Contents:

  1. Two single-column indexes vs one two-column index in MySQL?
  2. MySQL query finding values in a comma separated string
  3. In MySQL queries, why use join instead of where?
  4. Why would an IN condition be slower than “=” in sql?
  5. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  6. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  7. Can table columns with a Foreign Key be NULL?
  8. Importance of varchar length in MySQL table
  9. MySQL not using indexes with WHERE IN clause?
  10. MySQL dump by query
  11. single fixed table with multiple columns vs flexible abstract tables
  12. SQLite – ORDER BY RAND()
  13. SQL – How to transpose?
  14. MySQL equivalent of DECODE function in Oracle
  15. How to delete Duplicates in MySQL table
  16. How does table alias names affect performance?
  17. Performance issue in using SELECT *? [duplicate]
  18. Favourite performance tuning tricks [closed]
  19. Best database field type for a URL
  20. Query that ignore the spaces
  21. How to Optimize Queries in a Database – The Basics
  22. MySQL – how to front pad zip code with “0”?
  23. Create date from day, month, year fields in MySQL
  24. Find rows that have the same value on a column in MySQL
  25. what is the difference between GROUP BY and ORDER BY in sql
  26. How do I list all the columns in a table?
  27. How do you interpret a query’s explain plan?
  28. VARCHAR as foreign key/primary key in database good or bad?
  29. “SELECT *” vs “SELECT ” for performance
  30. Oracle , != , ^= operators

Leave a Comment