From: Johan De Meersman Date: February 9 2011 6:10pm Subject: Re: Replacing MS SQL with MySql List-Archive: http://lists.mysql.com/mysql/224346 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174be65611336a049bdd60cf --0015174be65611336a049bdd60cf Content-Type: text/plain; charset=ISO-8859-1 On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz 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 ? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0015174be65611336a049bdd60cf--