List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:April 6 2007 10:25am
Subject:Re: bulk insert optimization required
View as plain text  
M Imran Siddiqui wrote:
> 
> If i build INSERT statement myself , then the problem is that i have
> to do conversion from different datatypes to string.( for example from
> datetime to string ).
> Which ofcourse will be a overhead.

That's exactly what happens already!

If you were under the impression that when you send an integer to the 
database that it travels to the server as a 32-bit binary value, you 
were mistaken.  SQL is text.  Even BLOBs are not immune from this.

If you want a database that deals with binary data on the wire, MySQL is 
not the right choice.  You want to look at something more like Berkeley DB.
Thread
bulk insert optimization requireda b4 Apr
  • Re: bulk insert optimization requiredMr.Dragomir Stanchev4 Apr
    • Re: bulk insert optimization requiredWarren Young5 Apr
      • Re: bulk insert optimization requireda b5 Apr
        • Re: bulk insert optimization requiredWarren Young5 Apr
          • Re: bulk insert optimization requiredM Imran Siddiqui5 Apr
            • Re: bulk insert optimization requiredWarren Young6 Apr