Paging Technique

Questoin

I am using Sql Server 2000.

I have a table named Cities which has more than 2600000 records.

I have to display the records for a specific city page wise.

I don't want to compromise with performance.

Can anyone has the idea?

Waiting for your fruitful response.

Happy Day And Night For All

Muhammad Zeeshanuddin Khan

Hi Muhammad,

Check out this article. The idea behind is that you only fetch the records from the database that you display on the active pageIndex.

Succes!

Rutger van Hagen

Paging

I'm looking for an efficient generic T-SQL paging
technique
that would be able to give me a page result under
different sorting
I done a lot of web searching but didn't find any
tnxPlease dont MULTI-Post... I've already answered this in the other
group and dont wish to answer it a 2nd time.
if more than one group is relevent (as in this case) then CROSS-post
your questions then when someone replies it will automatically cross
post the replie.
to cross post put ALL the names of the groups in the to field
seperated by a semi colon (depending on browser app)
hth.
Al.
On Tue, 13 Jan 2004 10:12:11 -0800, "Bnaya Eshet"
<bnaya_eshet@.splsoftware.com> wrote:
>I'm looking for an efficient generic T-SQL paging
>technique
>that would be able to give me a page result under
>different sorting
>I done a lot of web searching but didn't find any
>tnx