Re: 100,000 rows table, and i only want row 500-549, how do i do it?
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!
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.