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? Forbes -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Steve Cassidy Sent: 28 August 2008 11:17 To: [email protected] Subject: Re: White Papers Compare & Contrast FMP & MS Access Ha ha! Strangely that particular comparison is not in the FMI pdf!! But if your sole purpose was to query sql data, Filemaker is fairly obviously not the right software choice. What the video did not show was the ease or complexity of creating a decent interface for that list data. Steve On 27 Aug 2008, at 23:06, Flora, Charlene wrote: > Here is a link comparing Alpha5, Access and FileMaker > > http://www.alphasoftware.com/VideoNewV9/comparea5_access_fm.swf -- ******************************************************************************** The information in this email and any files transmitted with it is confidential and may be legally privileged. It is intended solely for the addressee and others authorised to receive it. If you are not the intended recipient,, any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Prospects Services Limited is a limited company registered in England and Wales. Reg No: 3042176 Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1 1LT. If you have received this email in error please notify: [EMAIL PROTECTED] http://www.prospects.co.uk This footnote also confirms that this email message has been swept for the presence of computer viruses ********************************************************************************
