Is 10,000 Records Too Many? 4

[Sam050507]

Probably a dumb question, but is 10,000 records in a table with, say, ten to twenty fields too much for MySQL to chug through?

How big is "too big"?

 

[TonyGroves]

Certainly not. MySQL can easily handle millions of records in a table. Nothing is "too big".

 

[Sam050507]

Thank-you, Tony.

So 10k records in a table won't slow down the processing time too much as, say, two tables with 5k records?

I'm trying to find out if there will be an overly-significant lag time for the user.

 

[TonyGroves]

Not at all. Keep your database structure simple, using indexes where appropriate, and you'll get good performance. Complicating the structure only slows things down (in general).

 

[guelphdad]

if your tables are not indexed and you do a lookup of a column or a join between two tables, your query could be significantly slower with only a few thousand rows than a table of multiple millions of rows that is properly normalized data and properly indexed.

 

[lgarner]

Two tables would be much slower as each search would have to run twice. I have a server with over 500 databases, many with tables exceeding 20M records with a lot more than 20 fields. No problems if the index is good.

 

[Sam050507]

Many thanks to each of you.

It's a simple set up, basically.

It tracks truck numbers and trucking companies.

Each company can only have one truck number, but there may be many such numbers, one for each respective company.

 

[KarveR]

we track by order number, group by loads and subset by products per load. The tables run at around 8 million records each for any given month with the audit trail hitting 30million+ per month.

dont be shy, just get damn good hardware , lots and lots of ram and multithreading processors.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[snowboardr]

http://www.mysql.com/why-mysql/case-studies/

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]