RE: URGENT ! fusebox model and site search

[Paul Smith]

Hardly the same job.  LIKE 'bah%' uses an index.  LIKE '%bah%' does not.
BIG difference in speed.

best,  paul

At 07:56 AM 5/31/01 -0800, you wrote:
>Thats the 2nd person to mention this. Do y'all really do db searches with
>Verity? That seems so weird to me, I mean when a SQL 'LIKE' statement does
>the same job



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/fusebox@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists