Custom paging and 190,000 record

[SOS]

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]

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"