From: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De Meersman
Sent: Wednesday, February 09, 2011 1:10 PM
To: Jerry Schwartz
Cc: Y z; mysql@stripped
Subject: Re: Replacing MS SQL with MySql
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz <jerry@stripped> wrote:
[JS] Actually, I've done a lot of tracing recently (to solve my own
performance problems), and Access 2007 is very clever at pulling parts of a
dataset and a number of other things. For example, when you are browsing a
dataset Access will pre-fetch records 20 at a time.
Good to know that performance enhancements have been made, but what I'm specifically
thinking of is joins between remote tables - have you got data on how it handles those ?
[JS] I don’t have any data at the moment. I know that I tried outsmarting Access
with pass-through queries, with little luck.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com <http://www.the-infoshop.com/>
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel