Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
slow db performance after blackberry application is restarted
15 views
Skip to first unread message
Sherwin
Jun 15, 2010, 12:57:56 AM6/15/10
to
I'm using UltraLiteJ 11.0.1.2436 on
BlackBerry (OS 4.6 thru 5.0) and am experiencing extremely
slow commits after the app is restarted. The database is in
persistence store memory and created the first time the app
is started and inserts of a simple row (an id and varchar)
are very fast. (0.1s per 100 on device). After exiting and
restarting the app the database config is identical to how
it was initially created, however the connect is atrociously
slow (15s) and the subsequent inserts take 4s per 100. Any
insights?
I've tinkered with page size, cache size, index persistence,
lazy load index, shadow paging and write at end but nothing
seems to work.
Sherwin
Jun 17, 2010, 3:12:16 PM6/17/10
to
Solved: Use the Connection.disableSynchronization( table-name ) method
for tables that aren't intended to be synchronized to a server. In my
case it was needed for all the tables.
for tables that aren't intended to be synchronized to a server. In my
case it was needed for all the tables.
0 new messages