For Android Start the data very slowly！

[GoogleCodeExporter]

org.h2.Driver.load();
    conn = DriverManager.getConnection("jdbc:h2:/sdcard/sample;ACCESS_MODE_DATA=rw;;LOG=0" + dbDir,"123", "1111");

/sdcard/sample dbfile >=200000 record data start time>20ms

Original issue reported on code.google.com by 168...@gmail.com on 3 Jun 2013 at 7:42

[GoogleCodeExporter]

Hi,

This is not a valid issue. Please use the Google Group instead.

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 3 Jun 2013 at 7:19

• Changed state: Invalid
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Hi,

I suggest to change the database URL / options:

- not use ACCESS_MODE_DATA=rw as it has no effect
- not use LOG=0 as it is dangerous
- not use user name and password as it is slower
- use the option FILE_LOCK=FS
- use the option PAGE_SIZE=1024
- use the option CACHE_SIZE=8192

But generally, opening a database will probably still take longer than 20ms. Is 
it really a problem? Doesn't take SQLite 20ms as well?

Original comment by thomas.t...@gmail.com on 8 Jul 2013 at 6:33

• Added labels: ****
• Removed labels: ****