Re: how to optimize this query

2005-05-27 Thread Kevin Weslowski
rks so much better...I'm more of a "tinker until it works kind of a guy"...maybe this whole scenario of mine might be handy for MySQL optimizer developers to take note of? Anyway, I appreciate your comments/suggestions, Shawn...it got me to have a second look at what I was doing

how to optimize this query

2005-05-25 Thread Kevin Weslowski
Hi, I've got a query that I believe should be giving me better performance than it is, since I've put indexes on all the appropriate columns...I'll include as much info as I can for anyone wishing to help me optimize the query/tables/indicies...thanks in advance for any assistance... the que

bug?? in MySQL Control Center 0.8.10-beta

2003-03-14 Thread Kevin Weslowski
r does this have to do with my table not having a primary key? thanks... Kevin * Kevin Weslowski Application Developer MBD (McNair Business Development Inc.) Direct: 789-0019 Fax: 789-7630 Email: [EMAIL PROTECTED] www.mcnairbd.com A head for business.