Professional Web Applications Themes

Help! MySQL Connector/J too slow for production use! - Coldfusion Database Access

I've written an application using ColdFusion that will be targeted towards 1 million+ users. I've done all my dev against MS SQL Server in the past but decided to switch to MySQL for this new project. But I'm having a huge problem and it absolutely kills me that I can't find anybody writing about it. The problem is, the query overhead is 10x higher in MySQL than for MS SQL Server. For example, I can run a very simple SELECT against both servers and I get these response times (running the query 100x and timing it) MS SQL Server: about ...

  1. #1

    Default Help! MySQL Connector/J too slow for production use!

    I've written an application using ColdFusion that will be targeted towards 1
    million+ users. I've done all my dev against MS SQL Server in the past but
    decided to switch to MySQL for this new project.

    But I'm having a huge problem and it absolutely kills me that I can't find
    anybody writing about it.

    The problem is, the query overhead is 10x higher in MySQL than for MS SQL
    Server.

    For example, I can run a very simple SELECT against both servers and I get
    these response times (running the query 100x and timing it)

    MS SQL Server: about 1ms per query
    MySQL: About 10ms per query

    The application itself runs pretty fast and I've optimized it for speed;
    however, MySQL being often touted as faster for simpler operations, I never
    expected to run into a performance problem there.

    Has somebody encountered this? Has anybody fixed it?

    I'm using CFMX7 and the latest JDBC connector.

    Sunny

    shirai Guest

  2. #2

    Default Re: Help! MySQL Connector/J too slow for production use!

    shirai wrote:
    > The problem is, the query overhead is 10x higher in MySQL than for MS SQL
    > Server.
    It kind of sounds like you're talking about two separate things.
    "Overhead" to me is a memory usage issue--are you seeing high memory
    usage when you use the MySQL driver? Speed is a separate issue.
    > For example, I can run a very simple SELECT against both servers and I get
    > these response times (running the query 100x and timing it)
    >
    > MS SQL Server: about 1ms per query
    > MySQL: About 10ms per query
    What version of the MySQL driver are you using? How do you have it set
    up in CF? I've always seen extremely comparable speeds between MySQL
    and SQL Server. If anything MySQL can tend to be faster for certain
    operations depending on the table type you use in MySQL (InnoDB vs. ISAM).
    > I'm using CFMX7 and the latest JDBC connector.
    Latest meaning what version of the driver specifically? Is this MySQL
    5? What table type are you using? How specifically do you have your
    datasource defined in the CF administrator?

    Matt
    --
    Matt Woodward
    [email]mpwoodward[/email]
    Adobe Community Expert - ColdFusion
    mpwoodward *ACE* Guest

Similar Threads

  1. #40085 [NEW]: PHP/MySQL connector and Stored Procedure problem
    By edward_chan at hotmail dot com in forum PHP Bugs
    Replies: 2
    Last Post: January 10th, 07:52 AM
  2. MySQL Connector/J - driver not recognised
    By erasmus in forum Coldfusion Server Administration
    Replies: 1
    Last Post: October 22nd, 01:49 PM
  3. How do I connect with MySQL Connector/NET 1.0
    By Gerrit de Haan in forum MySQL
    Replies: 4
    Last Post: June 9th, 08:43 AM
  4. mysql-connector-java sadness
    By Walter Vaughan in forum MySQL
    Replies: 3
    Last Post: May 11th, 01:08 PM
  5. MySQL 4.1 & CFMX 6.1 connector problems
    By Babray in forum Coldfusion Database Access
    Replies: 13
    Last Post: September 29th, 12:17 AM

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