List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:February 9 2011 6:42pm
Subject:RE: Replacing MS SQL with MySql
View as plain text  
 

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.

 

Regards,

 

Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

 

860.674.8796 / FAX: 860.674.8341

E-mail: jerry@stripped 

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



Thread
Replacing MS SQL with MySqlY z9 Feb
  • Re: Replacing MS SQL with MySqlJohan De Meersman9 Feb
    • RE: Replacing MS SQL with MySqlY z9 Feb
      • RE: Replacing MS SQL with MySqlDavid Brian Chait9 Feb
    • RE: Replacing MS SQL with MySqlJerry Schwartz9 Feb
      • Re: Replacing MS SQL with MySqlJohan De Meersman9 Feb
        • RE: Replacing MS SQL with MySqlJerry Schwartz9 Feb
          • Re: Replacing MS SQL with MySqlJohan De Meersman9 Feb
  • Re: Replacing MS SQL with MySqlReindl Harald9 Feb
    • Re: Replacing MS SQL with MySqlJohan De Meersman9 Feb
      • RE: Replacing MS SQL with MySqlDavid Brian Chait9 Feb
        • Re: Replacing MS SQL with MySqlJohan De Meersman9 Feb
  • RE: Replacing MS SQL with MySqlJerry Schwartz9 Feb