MySQL Forums
Forum List  »  InnoDB

Re: performance issue
Posted by: Muneera h
Date: March 15, 2015 12:28AM

there is a group by text_topic_text_medium_id_text_medium!

the query should count the files that contains specific bi-gram in each medium.
from inside out:
select files ids that contain the bi-gram
select meta data id for the selected files
count the files in each medium

flag1..5 is an integer flags I need them to know if the file processed or not.


I just noticed the redundancy, thanks.

and about auto increment without it I got error in the code if I insert a new record

Options: ReplyQuote


Subject
Views
Written By
Posted
1801
February 24, 2015 06:01AM
1015
February 27, 2015 01:02AM
1138
February 28, 2015 11:50PM
1050
March 04, 2015 08:04PM
1121
March 10, 2015 01:49AM
993
March 12, 2015 10:45PM
Re: performance issue
1020
March 15, 2015 12:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.