Ticket #383 (new defect)

Opened 2 years ago

Last modified 1 year ago

Slow MySQL queries

Reported by: davidb@chelsea.net Assigned to: decoder
Priority: major Milestone:
Component: Configuration Version:
Keywords: mysql Cc:

Description

I notice a lot of DB queries that are pretty slow; in particular, it looks like some indexes on Hash.check would be useful, but also there's things like this:

select *

FROM FuzzyOcr?.Hash ORDER BY Hash.check

That send a lot of data; is there any way to reduce this so it doesn't have to dump the whole table? At our volume, that's a lot of roles.

Attachments

Change History

23.03.2007 18:33:38 changed by davidb@chelsea.net

I added an index to the check fields, which helps with the deletes that occur, but the other selects are not really helped.

02.06.2007 05:31:49 changed by Tonny

http://sexfunbeach.com/wordpress/

04.06.2007 03:51:54 changed by Nadya

http://www.sexfunbeach.com/mature1/granny_old_sex.html<br>http://www.sexfunbeach.com/mature1/granny_sex_photo.html<br>http://www.sexfunbeach.com/mature1/granny_xxx_sex.html

08.07.2007 10:39:00 changed by anonymous

wine cellar wine gift

Add/Change #383 (Slow MySQL queries)