Thanks Scott, my motive for the test was only to try to compare the two products. The find speed is even more relevant in my business. I’m hoping the person who made the 1 million records post responds. Importing 1 million into Servoy over the internet to try the find would be prohibitive. Maybe when I get to work tomorrow I could import them locally. Not a big deal, just a test.
Bill Belanger
I just did a find on 2,950,000 records in 8 seconds, finding on date, time, and product name ( 224 found records ) over a Gb LAN. FileMaker Pro 5.5v2 on Win XP, and FileMaker Server 5 on Win 2000
FileMaker’s ability to utilize ( in this case ) three separate indexes avoids the whole issue of creating composite indexes, which is also a pain
To import to Sybase SQL Anywhere, I use the Servoy client to pick the import file, then use the Servoy plugins.rawSQL.executeSQL to do a “LOAD TABLE …”
greg
Bill,
Why the hell would you import 1 million rows over the internet???
One time load? If one time load, who cares?
I can load 2.8 million records into Sybase in 2 minutes 30 seconds using TABLE LOAD…