Ok,
@Yahel:- For the insertion of same records on a Palm device(Say Palm Pre) ,
its taking 3 seconds..
On an IPhone , its taking 1 or 2 seconds..
Here is an example of what i am doing..
private Boolean addAlbumDB(int AlbumId, String Name, String Label,
int MultipleArtists, int ArtistId) {
long result = -1;
try {
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_ID, AlbumId);
initialValues.put(KEY_NAME, Name);
initialValues.put(KEY_LABEL, Label);
initialValues.put(KEY_ARTIST_ID, ArtistId);
initialValues.put(KEY_MULTIPLE_ARTISTS, MultipleArtists);
result = db.insert(DATABASE_TABLE, null, initialValues);
} catch (Exception e) {
Log.i("Exception in addAlbumDB", "" + e.toString());
return false;
}
if (result == -1)
return false;
return true;
}
The above function is called for around 2000 times..
Similarly there are 2 3 more functions for other tables.
Thanks,
Alok.
On Mon, Apr 12, 2010 at 2:33 PM, Michael Rueger <mike.rue...@gmail.com>wrote:
> On 4/12/2010 10:59 AM, Yahel wrote:
>
>> Hi Alok,
>>
>> Posting some logic, or some sql would help us see if you are missing
>> something :)
>>
>
> (excessive) use of indices comes to mind :-)
>
> Michael
>
>
>
>> Yahel
>>
>> On 12 avr, 08:50, Alok Kulkarni<kulsu...@gmail.com> wrote:
>>
>>> Hi,
>>> I am inserting around 7000 to 8000 records in my database having 4 tables
>>> each having 3 to 4 columns.Its taking me around 22 seconds to do the
>>> insertion which is i think is too long. I am using transaction while
>>> doing
>>> this without which its taking around 55 seconds.
>>> According to SQLite documentation , inserting 10000 records in a database
>>> takes time around 2 to 3 seconds.
>>> Am i missing something , or is the behaviour correct?
>>> Thanks,
>>> Alok
>>>
>>
>>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>
> To unsubscribe, reply using "remove me" as the subject.
>
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
