Deployment problem with large file?

[AlterX]

Hi,
i'm facing with a strange problem;
i've an app that use an sqlite3 file as a database; through .pro directive i copy it with the app during a deployment (.sources = my.db).
If i create a db with a dimension of 45/50 mb, qtcreator is able to deploy all and run the app on the device;
if i create a db with a dimension of 80/90 mb, qtcreator start the deployment, after a bit progression of the progressbar, it remains so for a long time (10/15 minutes) without a progression.
I must close qt creator and reboot the device (because of problem on an open file on the device) and TRK enabling is displayed if i start a new deployemen!

Is this a bug or a timeout or other?

Thanks
Gianni

[danhicksbyron]

You're unclear as to what you mean by "deployment". Are you having trouble building the app, or trouble installing the app onto the phone from Creator? If the latter, have you tried building the app and then installing the sis via Ovi?

[AlterX]

You're unclear as to what you mean by "deployment". Are you having trouble building the app, or trouble installing the app onto the phone from Creator? If the latter, have you tried building the app and then installing the sis via Ovi?

Yes i mean exactly start the app through QTcreator; if i install it manually, via ovi, my sqlite db is empty (this approch, both with 45/50 and 80/90 mb file),
Because of the creation of empty file as the behaviour of the sqlite API, i think.

[ltomuta]

It does not matter where you try to install it through, Ovi or Qt Creator, the size of the package must be the same and therefore the results must be similar. If Qt Creator (or rather its TRK interface) hangs when attempting to install this large file, you may want to report this as a bug. However, you may also want to consider an alternative way to work with your application, sending those 80MB to the device each time you complete a new build is at least a waste of time if not an invite for troubles.

[AlterX]

It does not matter where you try to install it through, Ovi or Qt Creator, the size of the package must be the same and therefore the results must be similar. If Qt Creator (or rather its TRK interface) hangs when attempting to install this large file, you may want to report this as a bug. However, you may also want to consider an alternative way to work with your application, sending those 80MB to the device each time you complete a new build is at least a waste of time if not an invite for troubles.

Ok i think i report that...my real testing comes with a stripped version (up to 2mb) due to obviously long time; that above is a testing for a complete app (production) that i must try before release it!

[danhicksbyron]

What happens if you install, say, a 10MB database? (And have you verified that there is room on the phone for the file you're installing, keeping in mind that it may be "staged" on a drive different from the one you target for the install?)

[AlterX]

What happens if you install, say, a 10MB database? (And have you verified that there is room on the phone for the file you're installing, keeping in mind that it may be "staged" on a drive different from the one you target for the install?)

Well..i've tested it with a poor version (for normal development) of 2mb and a complete version (not optimized) of 45mb and both work well...i so that the app can be installed everywhere, but i refer to it whitin the app only through a db name (so locally in the box of the app).
A good solution, i think, is to install the app and after download the db (zip format) over the internet (i've already implemented it in other app).

[ltomuta]

What phone are you using for testing and how much free storage space is there on that drive. You should have some 2x the size of the SIS file available for the installation to succeed, especially if the installation is in fact an update, applied to an already large package.

[AlterX]

What phone are you using for testing and how much free storage space is there on that drive. You should have some 2x the size of the SIS file available for the installation to succeed, especially if the installation is in fact an update, applied to an already large package.

I'm using an N8 and i've up to 178mb (a sis with complete db is about 33mb). Unfortunly QtCreator can deploy only on C:, i suppose.
Anyway, i'm searching without success the information about DEPLOYMENT directive in .pro (here I can use xxxx.path using a relative path, but i don't remember the syntax).

Thanks to all
Gianni

[danhicksbyron]

If you install via Ovi you can install on any drive (though of course testing is more of a problem).

[AlterX]

I created a download service to get a database via internet.
I tested it with simulator and all work well; if i query the db a result is found.
I tested it on device and, even it give me successfully download (same of simulator), when i query the db, nothing is found!!
Why?

[danhicksbyron]

I'm guessing you're not putting the file where you think you are. If a SQLite file is not found then SQLite will happily create a new, empty one.

Use QFile to check for the existence of the file before opening. Also, SQLite is an oddball and insists on "\" for file separators. Best thing to do is to find the file with QFile, check exists(), retrieve it's full path (QFileInfo(QFile)::absoluteFilePath()), and then use QDir::toNativeSeparators() to convert the "/" characters to "\". Then you finally set the DB file for SQL to open.

[AlterX]

I'm guessing you're not putting the file where you think you are. If a SQLite file is not found then SQLite will happily create a new, empty one.

Use QFile to check for the existence of the file before opening. Also, SQLite is an oddball and insists on "\" for file separators. Best thing to do is to find the file with QFile, check exists(), retrieve it's full path (QFileInfo(QFile)::absoluteFilePath()), and then use QDir::toNativeSeparators() to convert the "/" characters to "\". Then you finally set the DB file for SQL to open.

I've already checked if the file exist...but hey, you have right!
Sincerily i don't know if is a absoluteFilePath or NativeSeparators, but now it works very well!
Thanks to all for the great support!
I think the only bug is the transfer of the big file through QtCreator.

Bye
Gianni