SQL speed
Will you pick up any speed using SQL with F 9.0 doing "finds",
"sorts", etc. or will it be the same since FM is doing the work?
Thanks
Re: SQL speed
On 2007-07-20 07:47:13 -0500, jc [at] agncs.com said:
> Will you pick up any speed using SQL with F 9.0 doing "finds",
> "sorts", etc. or will it be the same since FM is doing the work?
>
> Thanks
Seems to me it is about the same as a regular FM find request. I'm
testing FM9 right now with a SQL database with millions of records and
FM finds are horribly slow on the large tables, whereas if I just do a
SQL import through FM its fairly fast.