BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 08-06-2009, 08:35 PM   #1 (permalink)
Knows Where the Search Button Is
Join Date: Jul 2009
Model: 7100T
Carrier: Sprint
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default UltraLiteJ insertion is to long

Please Login to Remove!

I am using Sybase UltraLiteJ database and I need to insert 100 rows in one table. It takes me about 10 sec for insertion when I use Insert SQL statement with commit. It is too long.

Is it possible make insertion much faster?


Old 08-11-2009, 03:59 AM   #2 (permalink)
New Member
Join Date: Aug 2009
Model: 8300
Carrier: none
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts

I use UltraLiteJ for BlackBerry from SQL Anywhere 11.0.0 Developer Edition.
The performance of this embedded DBMS is ugly. 350 inserts takes more then 6 s on simulator (I have no device now). And according to data from the first post simulator do inserts ~100 times faster then device... In fact, I need to insert many more records to initialize DB.

Can anyone suggest another embedded DBMS with SQL support for BlackBerry? Or is there a way to make SQL run faster?

Last edited by d15er : 08-11-2009 at 04:03 AM.

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.