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
PIN: N/A
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?

Thanks,

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

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.
Offline  
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 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.