Re: [sqlite] LOW performance with VIEW and ANDROID

On Sat, 27 Apr 2013 07:06:31 -0700 (PDT) Gianni Sassanelli wrote: > I have a slow performance if i USE the view but only when i use it > from ANDROID I don't know if it will help, but the following query should produce the same results and might execute faster: SELECT

[sqlite] LOW performance with VIEW and ANDROID

Hi experts, i'm using a SQLLITE for my ANDROID APP I have a slow performance if i USE the view but only when i use it from ANDROID the scenario is the following: I have a table defined as CREATE TABLE ArMpCol ( Id Integer PRIMARY KEY, Id_Ar int, Id_ArMpCol int,

Re: [sqlite] sequential row numbers from query

Hi Hitesh, Attached all the VB6 code to do with this. Ignore all the Debug stuff and also all the RaiseEvent lines. Note that this uses the free VB SQLite wrapper from Olaf Schmidt and if you don't use that then that is very much recommended. Let me know if you want that and I will explain. Also

Re: [sqlite] sequential row numbers from query

Ya I am interested to know more. My mail ID hitesh.ambal...@gmail.com Thank you so much -- View this message in context: http://sqlite.1065341.n5.nabble.com/sequential-row-numbers-from-query-tp47370p68515.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Programming API vs console

On 27 Apr 2013, at 8:34am, Igor Korot wrote: > In the other area of the program I have a transaction that does 5 or 6 > inserts and no selects. > This transaction works fine as I just verified. > > Now in the failing case the flow goes like this: > > First the program

Re: [sqlite] Port SQLite to VxWorks 6.8

Just put: pNew->ctrlFlags |= UNIXFILE_DELETE; instead of isDelete = 0; And remove : if( isDelete ) pNew->ctrlFlags |= UNIXFILE_DELETE; Worked for me, but I built SQLite for RTP. Does not metter here. Regards -- View this message in context:

Re: [sqlite] sequential row numbers from query

Have a look at this thread in the archive: find sequential groups It can be done with SQL, but it is slow and it can be done enormously faster in code. I did this in VB6 and let me know if you are interested and I mail you the code off-list. RBS On Sat, Apr 27, 2013 at 8:10 AM, hiteshambaliya

Re: [sqlite] What pragma to use to get maximum speed (at expense of safety)?

Thanks everyone, I cannot apply all the suggestions (for example I do use foreign keys), but probably I can improve the performance of the calculations. On Sat, Apr 27, 2013 at 6:48 AM, David King wrote: >> The idea of temporary tables in-memory is nice, but I do not know

Re: [sqlite] Programming API vs console

Amit, On Sat, Apr 27, 2013 at 1:00 AM, Amit Chaudhuri wrote: > CREATE TABLE playersdrafted(playerid integer, id ineteger, > > Don't think ineteger is what you really mean.:) > Seen it twice now so guessing it's actually in the code > Why you say so? It is a

Re: [sqlite] Programming API vs console

CREATE TABLE playersdrafted(playerid integer, id ineteger, Don't think ineteger is what you really mean.:) Seen it twice now so guessing it's actually in the code On Sat, Apr 27, 2013 at 8:34 AM, Igor Korot wrote: > Simon, > In the other area of the program I have a

Re: [sqlite] Programming API vs console

Simon, In the other area of the program I have a transaction that does 5 or 6 inserts and no selects. This transaction works fine as I just verified. Now in the failing case the flow goes like this: First the program updates couple of tables, then it inserts this particular record. This

Re: [sqlite] sequential row numbers from query

You are absolutely right but, I am using VB 6.0 and i have global general function which fill the data in grid so there is if serial number column in query is easy way so.. Any way to do in query??? -- View this message in context:

Re: [sqlite] Programming API vs console

On 27 Apr 2013, at 8:05am, Igor Korot wrote: > No. Using straight insert with values does not work. > Record still not inserted. Okay, so you now don't have to worry about parameters, or a sub-select or any of those things. What you have identified is that a simple INSERT

Re: [sqlite] Programming API vs console

Simon, On Fri, Apr 26, 2013 at 7:48 PM, Simon Slavin wrote: > > On 27 Apr 2013, at 3:29am, Igor Korot wrote: > > > sqlite> SELECT ownerid FROM owners WHERE ownername = 'Team 1' AND id = 1; > > 53 > > For testing, kill the sub-select in your INSERT