MySQL Forums
Forum List  »  Newbie

Re: Opinions on this schema please =)
Posted by: Willem vanSchevikhoven
Date: February 26, 2009 05:15PM


Just wanted you guys to know i got it working nicely.

I got 400 rows from a pool of 4000 items, 2000 articles, 4000 items->article -N:m tables and a few tags and values for them.
There were 2000 initial items after the join on the item_types, the attributes took this down to 400.

The time this took was 0.0041s (0.06s). (I'm using query browser, what do these values mean, either one can be longer so im quire lost with them).

As i told in my last message, i added a table item_types to my schema to narrow down things like Rick suggested.

Options: ReplyQuote

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.