Professional Web Applications Themes

mySQL query taking too long to return - MySQL

Greetings, I'm using mySQL in a VB.NET application, connecting it through the myOLEDB Provider. However, it's taking way too long to retrieve data from the server. For instance I have a simple table with two fields: [epoch] and [pingRepply] wich houses approx 720,000 records. Retrieving the data using the MySQL Query Browser it feetch all the rows in approx 5min. When I run my application it retireves the same data it takes more than half an hour. Can someone point me to the right direction?mySQL query taking too long to return...

  1. #1

    Default mySQL query taking too long to return

    Greetings,

    I'm using mySQL in a VB.NET application, connecting it through the
    myOLEDB Provider.

    However, it's taking way too long to retrieve data from the server.

    For instance I have a simple table with two fields: [epoch] and
    [pingRepply] wich houses approx 720,000 records.

    Retrieving the data using the MySQL Query Browser it feetch all the
    rows in approx 5min.

    When I run my application it retireves the same data it takes more than
    half an hour.

    Can someone point me to the right direction?mySQL query taking too long
    to return

    PJ on Development Guest

  2. #2

    Default Re: mySQL query taking too long to return

    PJ on Development wrote:
    > Retrieving the data using the MySQL Query Browser it feetch all the
    > rows in approx 5min.
    Why so long? Even 5 minutes for 720K rows is probably too long,
    indicating that there are things you can do to improve this. What have
    you done to yze the query with EXPLAIN, improve the coverage of
    indexes, tune the server for this application, etc.? Where's the
    bottleneck?

    Have you read the chapter of the MySQL manual on optimization?
    [url]http://dev.mysql.com/doc/refman/5.0/en/optimization.html[/url]
    You haven't given much information about the MySQL version, the
    platform, server config, the tables, or your query. There are many tips
    in that chapter that could potentially help a lot.

    I don't have any experience with VB or myOLEDB, so I can't comment on
    why the query is so much slower in your case. Levels of interface
    abstraction frequently introduce some performance cost (though a sixfold
    decrease in performance is unexpected).

    You should first see if you can improve the performance relative to the
    non-VB interface.

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Buffering taking too long
    By GlobalGreetings in forum Macromedia Flash Player
    Replies: 1
    Last Post: November 1st, 11:50 PM
  2. Replies: 0
    Last Post: November 4th, 05:38 PM
  3. Taking a long weekend
    By Teri Pettit in forum Adobe Illustrator Macintosh
    Replies: 5
    Last Post: February 6th, 03:09 AM
  4. Replies: 14
    Last Post: October 22nd, 05:59 AM
  5. Parsing MySQL query return
    By John in forum PHP Development
    Replies: 4
    Last Post: July 29th, 03:47 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