Speed SELECT vs. FindSingle

[Ruslan Zasukhin]

On 4/23/12 12:01 PM, "Karl Grob" <kgrob at mus.ch> wrote:

Hi Karl,

> Hi
> 
> Is there a difference in speed (Server), if I select a single record thru SQL
> or in Class-Way (tbl.fld.findsingle or even tbl.recId = x)?
> The use of the data is strictly read-only.
> I do have a lot of such single Selects.

Still depends ..

Where is server btw ?
Localhost?  Or in other city ?

For LOCAL DB, of course will win  FindSingle() ...
For remote db, this difference can be less because network overhead...

You need measure your case self I think


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]