UltraliteJ database Stores on Android

Hi, on-line documentation for ConfigPersistent interface responsible for setting database store options, like: setWriteAdEnd or setShadowPaging has a comment: “This method has no effect on UltraLite databases running on Android smartphones”. So, what persistent store configurations are available for Ultralite on Android?

Thansk

android ultralite

asked 29 Aug '11, 07:34

David
211●9●11●20
accept rate: 50%

flat view

One Answer:

active answers oldest answers newest answers popular answers

The defaults are supposed to be appropriate for most circumstances, so you should not have to pay much attention to the Configuration Object options until you wish to tune performance or address security issues. I typically use

ConfigFileAndroid config = DatabaseManager.createConfigurationFileAndroid(dbf, context);

I would say the ones of most importance are:

setCacheSize (initial cache for the database)
setPageSize (when creating a database)
enableAesDBEncryption (when creating a database) and
setDatabaseKey() for encryption

permanent link

answered 29 Aug '11, 09:05

Tom Slee
1.3k●2●16●29
accept rate: 29%

edited 29 Aug '11, 09:27

Volker Barth
40.2k●361●549●822

And I'll add further:

the cache is dynamically sized, so you shouldn't have to worry about that
the page size only needs to be changed if you have large rows which don't fit on 4k pages (the default) -- you'll know if this is the case because you'll receive an error to that effect on insert; sometimes applications can perform better with a smaller page size, but as Tom said that's a minor performance tuning issue

(29 Aug '11, 12:43) Tim McClements

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

ultralite ×162
android ×79

question asked: 29 Aug '11, 07:34

question was seen: 2,457 times

last updated: 29 Aug '11, 12:43

SAP SQL Anywhere

UltraliteJ database Stores on Android

Follow this question

Related questions