dilemma about mysql. using condition to limit load on a dbf

Posted by ondrobaco on Stack Overflow See other posts from Stack Overflow or by ondrobaco
Published on 2010-03-27T00:23:43Z Indexed on 2010/03/27 0:33 UTC
Read the original article Hit count: 342

Filed under:
|

hi, I have a table of about 800 000 records. Its basically a log which I query often. I gave condition to query only queries that were entered last month in attempt to reduce the load on a database.

My thinking is a) if the database goes only through the first month and then returns entries, its good. b) if the database goes through the whole database + checking the condition against every single record, it's actually worse than no condition.

What is your opinion? How would you go about reducing load on a dbf?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database