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
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