MySQL Forums
Forum List  »  Optimizer & Parser

data design optimization
Posted by: BattleMan BattleClan
Date: March 30, 2006 07:44AM

hi all, i need your help optimizing a data design

my data had the following structure
group structure :
* group id
* properties

activity structure :
* group id
* activity id
* property

what i have actually is data sets broken into groups. the requirment is to retrieve all of the structures belonging to groups answering certain criteria [for example a date range, or a name and so on]

i've tried to implement it using a single table with the following fields
* group id
* activity id
* properties

i let the main group set have the activity id of 0 and all of my queries are made using the criteria "AND ActivityID=0"

now is my problem. this design is badly performing. taking several seconds for a small 1500 data sets.

i thought about splitting the groups and the activities into seperate tables.
i would like your advice on how to optimize the performance.

thank you in advance, mati

"if google fetches data in less then an heart beat its possible for me too"

Options: ReplyQuote


Subject
Views
Written By
Posted
data design optimization
2783
March 30, 2006 07:44AM
1816
March 30, 2006 09:02AM
2417
March 30, 2006 01:43PM
1918
March 30, 2006 04:03PM
1787
March 31, 2006 04:59PM


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.