Re: Dynamic filtering results during query ?
Posted by: James Gordon
Date: April 17, 2007 02:22AM

I personally would create a number of views showing all of the data, data excluding books I own, data excluding authors I hate etc.

Also the author would be the author ID in the table, linking to a table of authors.

Speed wise I'm not sure. I assume that MySQL can ramp up to thousands of users/queries/rows. This would depend more on the server it was running on.

Create primary key indexes. I know that Oracle has a hash cluster that joins two tables together on their PK's so that data is close and pre-joined, not sure if MySQL has the same functionality?


Options: ReplyQuote

Written By
Re: Dynamic filtering results during query ?
April 17, 2007 02:22AM

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.