MySQL Forums
Forum List  »  Newbie

Re: Portal Database design help
Posted by: Shine Jones
Date: May 07, 2009 11:21PM

hey rick..
i am still waiting for your suggestion..

what i had said in my earlier post is correct or not..?

and really i am not able to understand much from this,,

{
SELECT ... FROM ... WHERE ... ORDER BY ... LIMIT 250,10;
may have to do the following:
1. Find all info about all the companies (including satisfying JOINs)
2. Sort
3. Skip the first 250 rows
4. Deliver 10.

This is hauling around lots of info about all the companies in a big tmp table.

More optimal (but not necessarily easy to achieve):
1. Fetch info about companies in the order given by ORDER BY
2. Skip over 250 rows
3. Deliver 10.
}

thanks a ton..

Options: ReplyQuote


Subject
Written By
Posted
April 27, 2009 12:12AM
Re: Portal Database design help
May 07, 2009 11:21PM


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.