Professional Web Applications Themes

mySQL C API vector binding support? - MySQL

Hello, I have a "slight" problem with the mySQL C API. I want to bind vectors for output/input prepared statements. However, the C API does NOT support such data binding. Is there ANY other way to do a bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one can do it with a loop, but obiously the goal is to have a higher performance.I tried it with a plain-old loop, but it is still slow. Oracle supports such feature and it is considerably faster than the usual loop-Insert (appr. 100 times faster for big queries) ! ! ! Please, advise. ...

  1. #1

    Default mySQL C API vector binding support?

    Hello,
    I have a "slight" problem with the mySQL C API. I want to bind vectors
    for output/input prepared statements. However, the C API does NOT
    support such data binding. Is there ANY other way to do a
    bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one
    can do it with a loop, but obiously the goal is to have a higher
    performance.I tried it with a plain-old loop, but it is still slow.
    Oracle supports such feature and it is considerably faster than the
    usual loop-Insert (appr. 100 times faster for big queries) ! ! !
    Please, advise.

    Thanx.

    Regards,

    Dragomir Stanchev

    The|Godfather Guest

  2. #2

    Default Re: mySQL C API vector binding support?

    "The|Godfather" <com> wrote:
     

    Right. This extension of the PS API is already on the TODO list.
     

    I doubt the client API being the reason for slow bulk loading. How did
    you come to this conclusion?

    The fastest method for bulk loading is LOAD DATA INFILE. Multi value
    INSERT (non-prepared) and single value INSERT (prepared) are
    approximately equally fast.

    For more tips regarding INSERT performance, please consult the manual:
    http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html


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

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

Similar Threads

  1. Problems with mysql support in PHP
    By jbottero in forum PHP Development
    Replies: 1
    Last Post: October 20th, 04:20 PM
  2. Replies: 0
    Last Post: July 10th, 01:04 PM
  3. What file formats support vector text?
    By Merrily_Schmid@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 3
    Last Post: February 11th, 11:29 PM
  4. Where do I activate mysql support?
    By fabriZio in forum PHP Development
    Replies: 3
    Last Post: July 12th, 01:32 AM
  5. PHP5 and MySQL support
    By Juz in forum PHP Development
    Replies: 0
    Last Post: July 9th, 09:34 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