search

kashipai / h2database

H2 Database for reference.
0 stars 0 forks source link

For Android Start the data very slowly！ #469

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
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

GoogleCodeExporter commented 9 years ago 
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