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
JC [ Fr, 20 Juli 2007 14:47 ] [ ID #1774061 ]

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.
Doug Anderson [ Mo, 23 Juli 2007 16:21 ] [ ID #1776075 ]
Datenbanken » comp.databases.filemaker » SQL speed

Vorheriges Thema: Portals, Table Occurrences and so on
Nächstes Thema: Perform script on exiting field