Custom paging and 190,000 record

Hi guys ,
i'm writing a web applications that search for a word in 190,000 records
(very large articles).
my database size is ~2 Gb.
i used of normal paging and show 10 record in each page but the
application was so slow.
i search for custom paging and found some articles wich use of this solution
:
1.create a temp table and then copy all of the records in that table.
2.select a range of records from this temp table (correspond to the page
number)

now , i think if i copy all of these records to a temp table
and select a range from the temp table , my application will be slower !!

so , what's the best solution for my problem?

Jared
Thu Jul 22 07:10:44 CDT 2004

I believe the solution you are referencing says you should select a range
from your main table and copy the output of the range to a temporary table,
then you bind to this temp table.

http://www.dotnetjunkies.com/Article/975BE770-E5DC-4610-870B-A82BDB9B8845.dcik

- OR -
Enter the following phrase into google "custom paging sql server create
table"

"SOS" <SOS@hotmail.com> wrote in message
news:OL8MuF%23bEHA.1656@TK2MSFTNGP09.phx.gbl...
> Hi guys ,
> i'm writing a web applications that search for a word in 190,000 records
> (very large articles).
> my database size is ~2 Gb.
> i used of normal paging and show 10 record in each page but the
> application was so slow.
> i search for custom paging and found some articles wich use of this
> solution
> :
> 1.create a temp table and then copy all of the records in that table.
> 2.select a range of records from this temp table (correspond to the page
> number)
>
> now , i think if i copy all of these records to a temp table
> and select a range from the temp table , my application will be slower !!
>
> so , what's the best solution for my problem?
>
>