[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-plusplus
Subject:    Re: bulk insert optimization required
From:       Warren Young <mysqlpp () etr-usa ! com>
Date:       2007-04-06 10:25:20
Message-ID: 46162010.6080401 () etr-usa ! com
[Download RAW message or body]

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.

-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    http://lists.mysql.com/plusplus?unsub=mysql-plusplus@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]