v16.1 Project Transfer timing MS Acess vs SQLite

[Paolo F Cantoni]

We're now investigating using SQLite for our project snapshot clones.  Previously we were transferring our SQL Server repository to a .eapx (MS Access) clone.  This took about 15 mins and produced a file just shy of 2GB (before compaction).  We are now exceeding the 2GB limit, and the transfer fails.  Hence we are looking at SQLite .qea files.

We can transfer the SQL Server repository to a .qea clone, but instead of 15mins it takes 2 hours!!!  (This is with v16.1 32-bit)  One test we ran with 64-bit took 20 hours for the same repository!

Is this to be expected?  Is something wrong with our setup?

TIA,
Paolo and      <--  J o y c e won't play!

[qwerty]

You probably have to ask the Sparx coders...

q.

[Mauricio Moya (Arquesoft)]

I'm not surprised. I've done performance tests with 32-bit and 64-bit versions and the results never show smaller times in 64-bit. Sometimes even longer.