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

Gems Level Switch, Series LS-3N, Pilot Duty 20VA, 120-240VAC, 209475
$20.0
Gems Level Switch, Series LS-3N, Pilot Duty 20VA, 120-240VAC, 209475 picture52 NEW at MostElectric: 1492-CJ6-3 ALLEN BRADLEY 1492CJ63 NEW
$3.53
52 NEW at MostElectric: 1492-CJ6-3 ALLEN BRADLEY 1492CJ63 NEW pictureMELTRIC 33-38043-HP DISCONNECT SWITCH *USED*
$80.0
MELTRIC 33-38043-HP DISCONNECT SWITCH *USED* picture50 NEW at MostElectric: 1492-JTC3T ALLEN BRADLEY 1492JTC3T NEW
$12.71
50 NEW at MostElectric: 1492-JTC3T ALLEN BRADLEY 1492JTC3T NEW pictureHONEYWELL LSD3K SWITCH *USED*
$65.0
HONEYWELL LSD3K SWITCH *USED* picture






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