You can use <cfquery> in lieu of cfstored proc and cache the results.
That should solve the speed for records 101-200, etc.

----- Original Message -----
From: Micha Schopman <[EMAIL PROTECTED]>
Date: Thu, 29 Jul 2004 13:33:48 +0200
Subject: RE: The search is killing the server. Please help!
To: CF-Talk <[EMAIL PROTECTED]>

Try using full text search, which gives far more superior speeds, and
superior search results. Why do you need 5000 results btw, do you really
think someone is going to browse them all?

Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to