LEON comments

Results 9 comments of


                                            LEON

create table WITHOUT ROWID

We are porting from FMDB and the original design of the table is without rowid. This table has huge number of rows and dedicated pk. Without rowid can save considerable...

create table WITHOUT ROWID

Well we do have experiment on it. The reality is that the difference is significant. Our db is 201MB in total with "WITHOUT ROWID" and this table has 1.5 million...

create table WITHOUT ROWID

I have also created a [test](https://github.com/leonylcatwork/WCDBTests). WCDBTestsTests.mm -> -testWithoutRowid 1.5M rows in a table makes 41MB (19.7% ) difference.

create table WITHOUT ROWID

Well that is the actual size it takes on disk. When you do `[db close]` there aren't any other files besides xxx.db. And it really makes no difference if you...

create table WITHOUT ROWID

This test repo has it: https://github.com/leonylcatwork/WCDBTests

Transaction now working, __psynch_mutexwait ()

So: WCTransaction -insertObjects:into: would be of no use? There are cases when we want to manually manage transactions. What would you recommend doing in that case?

Transaction now working, __psynch_mutexwait ()

Then you lose the ability to rollback the whole operation if something goes wrong :/

Transaction now working, __psynch_mutexwait ()

> Then call `insertObject:into` multiple times. > `[transaction rollback]` Do I get you wrong or something? Since ``` WCTTransaction *transaction = db.getTransaction; [transaction begin]; ret = [transaction insertObjects:models into:NSStringFromClass(Model.class)]; if...

Any API for sqlite3_interrupt()?

Will we be getting one in future release?