BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 08-06-2009, 09: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, 04: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 05:03 AM.
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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