Re: [GENERAL] loading only few rows from huge table

2004-12-29 Thread Bruno Wolff III
On Wed, Dec 29, 2004 at 06:54:31 -0800, Mark [EMAIL PROTECTED] wrote: In general you should keep replies copied back to the list so that other people can learn from and contribute to the discussion. Responding to messages in line makes it easier for people to follow the discussion. I will

[GENERAL] loading only few rows from huge table

2004-12-24 Thread Mark
Hi, I have a table with 100K rows. One of columns is a timestamp and indicates when this row inserted. What will the the best way of getting 10 latest rows from that table and introducing partial data retrieval (rows 50-60, 100- 120, etc) Thanks, Mark.

Re: [GENERAL] loading only few rows from huge table

2004-12-24 Thread Bruno Wolff III
On Wed, Dec 22, 2004 at 11:31:59 -0800, Mark [EMAIL PROTECTED] wrote: Hi, I have a table with 100K rows. One of columns is a timestamp and indicates when this row inserted. What will the the best way of getting 10 latest rows from that table and introducing partial data retrieval (rows