List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 24 2001 3:07am
Subject:Re: bulk insert / binary data
View as plain text  
At 6:59 PM -0700 10/23/01, Bob Purvy wrote:
>I'm doing just general feasibility studying of embedding MySQL in a 
>networking product, and I have a question that I haven't been able 
>to find the answer to after a fair bit of looking
>
>    -  is there some way to insert data that is already in INT 
>UNSIGNED form directly into a table, without converting it into 
>ASCII and then having it converted back again by the database?  (I 
>know I could use BLOB, but that would lose some of the benefits of 
>integer-ness.)  We would be using the C API.

No.


>
>This product generates *large* volumes of data, which is currently 
>all in UINT32 .  It would seem to be a large waste of scarce CPU 
>resources to have to convert every single column to and from ASCII. 
>(the only issue I could see would be the endian-ness of it, but that 
>could be managed.)
>
>Thanks for your help.


-- 
Paul DuBois, paul@stripped
Thread
bulk insert / binary dataBob Purvy24 Oct
  • Re: bulk insert / binary dataPaul DuBois24 Oct