Re: [sqlite] SQLite Database Crash

Dear Patel, When does your java program crashes ? At start-up when you open the database ? When you perform DB queries ? Which Java library do you use to interface sqlite ? How do you use it ? Do you perform queries that retrieve big quantity of data ? SQLite can be tuned to use more or less

Re: [sqlite] Undo-Redo

Dear Tom, There is a pragma that allows you retrieving the structure of a table : PRAGMA table_info(table_name); From the result of the command, you can programmatically create your triggers. Regards, Brice 2017-07-15 21:11 GMT+02:00 Thomas Flemming : > Hi Sqlite-users, > >

Re: [sqlite] REQUETES

Hello, Maybe replace "ZONAGES_SHP_TAB2016".'identifiant' by "ZONAGES_SHP_TAB2016"."identifiant" or by "ZONAGES_SHP_TAB2016".identifiant ? Regards, Brice 2016-08-31 15:21 GMT+02:00 Igor Korot : > Hi, > > On Wed, Aug 31, 2016 at 9:14 AM, REGIANY Lucie

[sqlite] Database Corrupt While Disk Full

Dear Simon, I am a little worried with your last post because, I must admint that I do not take special measures in my application when such errors occur to guarantee that no more DB access are performed. I have thus the following questions : 1. What would be the proper reaction to

[sqlite] Random performance issues with SQLite

Dear all, Just to give some feedback on this problem : I changed the HDD of my client, and configured his anti-virus to exclude the database directory. I don't know which one of those actions solved the problem, but it now seems to work like a charm. I will still wait a few days/weeks to be sure

[sqlite] Random performance issues with SQLite

Dear all, Thank you very much for those advices. I will try them and get back if it does not solve the issue. Regarding the advice of Simon on HDD starting to fail, I have one more question. In fact, I suspected this, as my client has other problems with his computer. But, in such case, I

[sqlite] Random performance issues with SQLite

OK, but if this scenario was at the origin of my problem, I guess I would have such a log each time a db query freezes ? If yes, then there is probably another problem, as I am sure I got such freezes with no such logs from sqlite. By the way, if the antivirus is at the origin of the problem,

[sqlite] Random performance issues with SQLite

Dear Richard, Thanks for your answer. The version of sqlite I am using is the 3.9.1 amalgamation. But, as stated above, I am not sure my freeze problem is linked to the strange log observed at my client as this log does not systematically appears on database queries that freeze. Those logs

[sqlite] Random performance issues with SQLite

Dear all, I experience some performance issues with SQLite. I have an application that uses SQLite to store user data, including agenda information. One of my client has a relatively big database (around 1.3Gb). I have indexed the database so that the queries take a reasonable time to execute.