Professional Web Applications Themes

MS Access with MySQL - Speed Issues - MySQL

I am using MS Access through the 3.51 ODBC connector with MySQL. I have quite a few speed issues and I was wondering if (other than not using Access ;) ) I was missing something. If I try to run a delete query from Access to delete every row in a table it is incredibly slow. If I run the same thing directly on the MySQL box from the Query Browser it is near instantaneous. Is there anything I can do to make the Access queries run faster? I am using Access 2003 SP2 and MySQL 4.1. I can't yet ...

  1. #1

    Default MS Access with MySQL - Speed Issues

    I am using MS Access through the 3.51 ODBC connector with MySQL.

    I have quite a few speed issues and I was wondering if (other than not using
    Access ;) ) I was missing something.

    If I try to run a delete query from Access to delete every row in a table it
    is incredibly slow. If I run the same thing directly on the MySQL box from
    the Query Browser it is near instantaneous. Is there anything I can do to
    make the Access queries run faster? I am using Access 2003 SP2 and MySQL
    4.1. I can't yet use 5 as my ISP doesn't support it yet.

    I have written some scripts on the MySQL side and these are very quick. Is
    there anyway I can trigger these from Access?

    TIA.


    Sam Guest

  2. #2

    Default Re: MS Access with MySQL - Speed Issues

    Post the query you use in MSAccess.

    "Sam Smith" <bob> wrote in message
    news:efb26e$lof$1$demon.co.uk... 


    Duane Guest

  3. #3

    Default Re: MS Access with MySQL - Speed Issues

    On Tue, 26 Sep 2006 12:16:27 +0100, Sam Smith wrote:
     

    Use the customization options on your query object to define it as a
    PassThrough query. Right click on the query, select "SQL Specific", then
    Select PassThrough query. Then make sure you use strict MySQL syntax
    as defined in the MySQL docs.

    This will bypass the Microsoft libraries (almost!) completely and let
    MySQL do it's query thing. MySQL is much better at it and everything
    works faster when Microsoft just butts out ;-)

    Thomas Bartkus


    Thomas Guest

  4. #4

    Default Re: MS Access with MySQL - Speed Issues

    "Thomas Bartkus" <net> wrote in message
    news:net...
     

    Thanks. I'll try that.

    ---
    Sam


    Sam Guest

  5. #5

    Default Re: MS Access with MySQL - Speed Issues

    "Duane Phillips" <askme> wrote in message
    news:com... 

    It can be anything. Even exporting tables. Everything is very slow. But I
    will try the Passthrough technique.

    Even a simple delete query will take a very long time over thousands of rows
    but the same query in MySQL itself takes less than a second.

    ---
    Sam


    Sam Guest

Similar Threads

  1. MySql tion and network speed
    By Chad J. Lemmer in forum MySQL
    Replies: 3
    Last Post: January 29th, 06:33 PM
  2. Cfdoent Speed issues
    By StokeyTCI in forum Coldfusion - Advanced Techniques
    Replies: 8
    Last Post: April 4th, 03:04 PM
  3. Horrible Speed issues? Win2k P4 2Ghz Machine
    By bshroyer webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 3
    Last Post: September 26th, 03:22 PM
  4. Balancing speed against OO design - optimization issues with PHP/MySQL
    By Jeffrey Silverman in forum PHP Development
    Replies: 3
    Last Post: August 12th, 08:28 PM
  5. Appletalk filesharing speed issues
    By JWolf6589 in forum Mac Applications & Software
    Replies: 2
    Last Post: July 30th, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139