Re: Sounds like & Contains

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

Posted by Jon Sacks on April 25, 2008 at 15:00:28:

In Reply to: Sounds like & Contains posted by Stephen Auerbach on April 23, 2008 at 10:12:36:

This talks to the whole idea of a server side select to return only the found record set therefore reducing the I/O with the client.

I do some of this via the ODBC tool I wrote where:

select customer.number, customer.name from customer where customer.name like '%jon%';

I only get back the selection I want where the pattern matches. It's amazing how Oracle can return this request on a multi million row file in seconds.

JSACKS<<

Follow Ups:


Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]