Re: [sqlite] Fast data duplication

2009-05-27 Thread Vasil Boshnyakov
] Fast data duplication Vasil Boshnyakov vas...@voicecom.bg wrote in message news:000c01c9de8b$16510a40$42f31e...@bg The short description is: we need to copy many records of a table in the same table but changing the Name value. So we have added a new function which process the names: Insert

[sqlite] Fast data duplication

2009-05-26 Thread Vasil Boshnyakov
Hello, We need to implement fast Insert into users ItemID, Name Select ItemID, Name from users where itemActive = 1; The short description is: we need to copy many records of a table in the same table but changing the Name value. So we have added a new function which process the

[sqlite] Blob truncation

2008-04-23 Thread vasil
Hello, I am trying to implement a simple file store based on the SQLite library. The idea is to use the SQLite as virtual folder. The logic is quite simple except the following detail: I need to read the files block by block (with 64k buffer size) and process each block with the zlib before