MySQL Forums
Forum List  »  Newbie

Re: 100,000 rows table, and i only want row 500-549, how do i do it?
Posted by: huizhang66
Date: June 03, 2005 04:12PM

Thanks!

Since which version "LIMIT" is available for MySQL?

Picking up only certain number rows from a select query. This is an important feature, but it seems that it was not in many database management systems only a few years ago.

I was looking for the "LIMIT" (or same kind function) in the InterBase Open Source Code version, and it was not in it. And I don't think it is in the FireBird at this moment too.

And I saw some oracle sql statements that have to select 50 items to display at a page from a 100,000 rows table. And the sql statments were to select all 100,000 rows first, and then only display 50 items a page. It was very slow. I guess when the database programmer wrote these sql statements, the feature like "limit" in mysql or "rownum" in oracle is not available.

Any inside knowledge some people can share with us about this issue? Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Re: 100,000 rows table, and i only want row 500-549, how do i do it?
June 03, 2005 04:12PM


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.