Professional Web Applications Themes

MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server??? - MySQL

"Ignoramus14359" <ignoramus14359NOSPAM.14359.invalid> wrote in message news:PXkPf.12450$vb4.142fe47.usenetserver.com... > MySQL 5.0: 41 minutes > SQL Server: 1 minute 50 seconds. > > I am not less than SHOCKED by this difference and would like to know > if there are any onbious tweaks that I could do. Turn off autocommit if you're using InnoDB. I'd guess that's the most likely performance expense, given the number of statements you mention. Also read the tips on these pages and try employing some of them: [url]http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html[/url] [url]http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html[/url] Regards, Bill K....

  1. #1

    Default Re: MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server???

    "Ignoramus14359" <ignoramus14359NOSPAM.14359.invalid> wrote in message
    news:PXkPf.12450$vb4.142fe47.usenetserver.com...
    > MySQL 5.0: 41 minutes
    > SQL Server: 1 minute 50 seconds.
    >
    > I am not less than SHOCKED by this difference and would like to know
    > if there are any onbious tweaks that I could do.
    Turn off autocommit if you're using InnoDB. I'd guess that's the most
    likely performance expense, given the number of statements you mention.

    Also read the tips on these pages and try employing some of them:
    [url]http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html[/url]
    [url]http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html[/url]

    Regards,
    Bill K.


    Bill Karwin Guest

  2. #2

    Default Re: MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server???

    Ignoramus14359 <ignoramus14359NOSPAM.14359.invalid> wrote:
    > My test was to run execute statement for 60,000 statements that are
    > DROP TABLE, CREATE TABLE and INSERT statements. One important thing to
    > know about this file is that the tables are truly huge (some tables
    > have hundreds of columns). So each INSERT is a enormous string, as you
    > can imagine.
    So this is a bulk import.
    There are *many* possibilities to speedup things.

    Row length does not matter so much. In fact it is recommended to use
    extra long rows via the multiple-value-insert syntax. But you may
    try prepared statements as well.

    More important are indexes (created before or after load).
    Make sure you have the MySQL buffers configured huge. Indexing
    performance will suffer from insufficient memory.
    > The client used to load these databases was a C++ app using either
    > ODBC (for MS Sql Server) or the native mysql.lib/dll for MySQL.
    >
    > Anyway, the results are as follows:
    >
    > MySQL 5.0: 41 minutes
    > SQL Server: 1 minute 50 seconds.
    >
    > I am not less than SHOCKED by this difference and would like to know
    > if there are any onbious tweaks that I could do.
    The first place to look would be the fine manual, of course:

    <http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html>


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    MySQL User Forums: [url]http://forums.mysql.com/[/url]
    Axel Schwenke Guest

Similar Threads

  1. Replies: 14
    Last Post: October 6th, 04:19 PM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. PHP vs Java performance on MySQL
    By Rajesh Kapur in forum PHP Development
    Replies: 2
    Last Post: August 14th, 11:20 PM
  4. Lousy Grid
    By Project Mayhem in forum FileMaker
    Replies: 7
    Last Post: July 3rd, 02:48 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