I've been using MySQL for a while for fairly light database development on
my XP machine. Currently, I am just starting a new project and have
experienced some big problems with MySQL today both on my office machine and
at home where running a particular query on a database freezes both the
database client, no matter what I am using, and pretty much kills my entire
machine.
The query is something like this:
SELECT * From job, company, division WHERE job.DIVISIONNUMBER =
division.DIVISIONNUMBER AND job.Active=1 AND division.CompanyNumber =
company.CompanyNumber AND job.ENTRYDATE BETWEEN '2000-3-13' AND '2005-2-23'
ORDER BY job.EntryDate DESC
Most queries seem fine, but this one in particular seems to kill my machine.
I was running some 3.xx version, but just upgraded to 4.1 and the problem
persists. Could someone clue me in as to why this might be?
Regards,
Jonathan
FAQ
Search
Profile
Private Messages
Log in
