On Aug 28, 2008, at 6:38 AM, Robertson, Forbes wrote:
Interesting...
I have just looked at the Alpha5 video. It has a 1,000,000 row table
on
MySQL which they show FM taking 1 minute to open and then a couple of
seconds to display a screen-full of data on each page down.
I have a 465,000 row table on MS SQL Server connected by ESS, this
takes
about 15 seconds to open on FM9, and approx 0.5 secs to scroll down a
page. This is a fairly large table with some 50+ fields (probably more
than the Alpha 5 demo which had 20ish fields).
I don't know if the differences in performance are due to the increase
in file size -- perhaps not because over ESS a 9000 row table takes
several seconds to open the first time. Or down to the difference
between MySQL and MS SQL server (or the respective FM drivers)? Or
that
they seem to be running everything on the same PC?
Thoughts?
I have a 3,558,225 row table in MSSQL and it is the biggest data
source in this filemaker file. The FM file lives on a fairly anemic P4
server with 2GB Ram and a single SATA drive, running FMSA 9. The MSSql
server is a Dell rack job with dual dual Xeons and shares a RAID with
other servers (mostly the file server). Regular gigabit network setup.
Other tables in the FM file are half-million records or less. I have
15 fields displayed in table view. On this Jan '07 MacBookPro, it
takes 3 seconds to open the file and display the first 24 rows of
data. Taking the rolodex slider and dragging to the last record,
pulls up a "Procesing sql query..." progress bar that lasts about one
minute. After that, you are free to move about with no delays, as the
entire data set is "in RAM" as it were. As long as the table stays
open it is fast; reopening makes you wait again. There is absolutely
no delay paging up or down. If one simply queries the table for info
(i mean, who looks at 3 and a half-million records?) like it is
intended to be used, then there aren't any delays at all.
So basically, that video is a lie. That is my thought.
geoff
