Professional Web Applications Themes

ODBC Connector very slow, Win XP Firewall - MySQL

The connection to my MySQL-server over the LAN was very slow - about 10 second to connect and query on a new installation. The problem was the Windows XP firewall: After opening the port 3306 (TCP) I had full speed. Only a note for someone who has the same problem :)) Gottfried...

  1. #1

    Default ODBC Connector very slow, Win XP Firewall


    The connection to my MySQL-server over the LAN was very slow - about 10
    second to connect and query on a new installation.
    The problem was the Windows XP firewall: After opening the port 3306
    (TCP) I had full speed.

    Only a note for someone who has the same problem :))

    Gottfried
    Gottfried Guest

  2. #2

    Default Re: ODBC Connector very slow, Win XP Firewall

    Gottfried Pauler wrote: 

    Another note is that ODBC is always a lot slower than direct connect (seen as
    big slowdown as half the performance from direct connect).


    --

    //Aho
    J.O. Guest

  3. #3

    Default Re: ODBC Connector very slow, Win XP Firewall

    Gottfried Pauler wrote: 
    if the port on the windoze xp firewall was closed, there should have
    never been a connection! I wonder why it would even let you have a
    connection regardless of speed?

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. Connector/J 5 slow with CFMX 7.02?
    By t.constantin in forum Coldfusion Database Access
    Replies: 4
    Last Post: March 6th, 12:06 PM
  2. Best to use ODBC Socket or mysql-connector-java-5.0.3?
    By Oliver in forum Coldfusion Database Access
    Replies: 4
    Last Post: September 9th, 02:23 AM
  3. Help! MySQL Connector/J too slow for production use!
    By shirai in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 13th, 01:24 PM
  4. Having Problems with JDBC to ODBC connector ColdfusionMX7
    By Head Shooter in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 10th, 09:37 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