[android-developers] SQLite database maximum size
Hello to everyone. We have a big SQLite database file (~11.6 Mb) that ships with application. All is good except strange problem on several devices (Samsung Galaxy S and Galaxy 580, both running Android 2.2). System can't open such db file. Logcat poor with only one error message: > sqlite returned: error code = 11, msg = database corruption found by source > line 40107 After that failure database file is deleted. So all data lost. Deleting several rows and reducing db file size to 11Mb solves problem. On other tested devices running 2.3, 3.x and 4.x version does not have such problem. So the question is: Does there are any documented limits to databases (size or rows count) for SQLite that ships with Android 2.2 and previous versions? -- 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
[android-developers] Re: SQLite database maximum size
Yes, database opening also fails in emulator On 17 фев, 13:46, Marcelo Henrique wrote: > will you Test in emulator ? > > 2012/2/17 HighFlyer > > > > > > > > > > > Hello to everyone. > > We have a big SQLite database file (~11.6 Mb) that ships with > > application. All is good except strange problem on several devices > > (Samsung Galaxy S and Galaxy 580, both running Android 2.2). System > > can't open such db file. Logcat poor with only one error message: > > > > sqlite returned: error code = 11, msg = database corruption found by > > source line 40107 > > > After that failure database file is deleted. So all data lost. > > Deleting several rows and reducing db file size to 11Mb solves > > problem. > > On other tested devices running 2.3, 3.x and 4.x version does not have > > such problem. > > > So the question is: > > Does there are any documented limits to databases (size or rows count) > > for SQLite that ships with Android 2.2 and previous versions? > > > -- > > 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 > > -- > - Marcelo Henrique - > "Se não puder se destacar pelo talento, vença pelo esforço." (Dave > Weinbaum) -- 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
[android-developers] Re: SQLite database maximum size
Version in emulator is 3.5.9 On 17 фев, 14:41, Marcelo Henrique wrote: > bug in SQlite 2.2. ? what version SQlite Database in 2.2? 2.3 ? 3.2 ? 4? > > 2012/2/17 HighFlyer > > > > > > > > > > > Yes, database opening also fails in emulator > > > On 17 фев, 13:46, Marcelo Henrique wrote: > > > will you Test in emulator ? > > > > 2012/2/17 HighFlyer > > > > > Hello to everyone. > > > > We have a big SQLite database file (~11.6 Mb) that ships with > > > > application. All is good except strange problem on several devices > > > > (Samsung Galaxy S and Galaxy 580, both running Android 2.2). System > > > > can't open such db file. Logcat poor with only one error message: > > > > > > sqlite returned: error code = 11, msg = database corruption found by > > > > source line 40107 > > > > > After that failure database file is deleted. So all data lost. > > > > Deleting several rows and reducing db file size to 11Mb solves > > > > problem. > > > > On other tested devices running 2.3, 3.x and 4.x version does not have > > > > such problem. > > > > > So the question is: > > > > Does there are any documented limits to databases (size or rows count) > > > > for SQLite that ships with Android 2.2 and previous versions? > > > > > -- > > > > 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 > > > > -- > > > - Marcelo Henrique - > > > "Se não puder se destacar pelo talento, vença pelo esforço." (Dave > > > Weinbaum) > > > -- > > 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 > > -- > - Marcelo Henrique - > "Se não puder se destacar pelo talento, vença pelo esforço." (Dave > Weinbaum) -- 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
[android-developers] Re: Is this template in java
Yes, its templates. Java use 'generics' term On 1 дек, 18:15, "SL@maxis" wrote: > Java format: > > ArrayAdapter(Context context, int textViewResourceId, List objects) > > Is the above template like in C++ ? > > I have a 15-year Java book; I think there is no such thing in there. > > I did a little search on net, but did not see documents explaining the > above. > > Thanks. > > -- > Using Opera's revolutionary e-mail client:http://www.opera.com/mail/ -- 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
[android-developers] Writing to SQLite database locks reading
Hi. I have large database which should be updated periodically. Update process is long enough and takes up to 10 seconds. Also I have one ListView with short description of objects. On item click activity with full object info should be shown. The problem is: object information storing in database and if update is performing its impossible to read necessary data due to locks in Java access layer to database. There are two cases: I may block UI until update finished, or information activity may be shown with empty labels and fills after update process finished. Both variants seems ugly to users. To reduce lock times, I make copy of *.db file, apply update data to it, and after INSERT and UPDATE statements completed, swaps original and updated *.db files. This technique reduce lock time to ~50 ms. But it increases total update time up to 5 seconds. Do you know other practices to deal with such situations? Maybe right solution is to implement Java wrapper on SQLite native functions without thread locks? -- 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