I was thinking I may need this query in the future. What I do now is use paging and only fetch 10 rows. How can you speed up this type of query?
select count(*) from table where month(due_date)=month(now()); _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
