[sqlite] v3.14.1 Speed is real

2016-08-26 Thread Jose I. Cabrera
I just wanted to say thank you for the fixes on this version. It has speed up many of my updates. I have not really found how fast, but, I have notice the increase in speed on the system with the updates. Thanks. josé ___ sqlite-users mailing list

[sqlite] 64bit DLL vs 32bit

2016-05-06 Thread Jose I. Cabrera
Greetings! I have found that the Windows 32bit DLL works slower on a 64bit machine than on a 32bit. I would have thought that the calls from the applications would have the same response for both machines since the application is a 32 bit application. Anyone thinks otherwise? Thanks. jos?

[sqlite] Last time analyze was ran

2016-04-12 Thread Jose I. Cabrera
, but the log files say it is running. However, the searches are getting slower and slower. It should not be too hard to add it as part of the .schema repor, **I think**. Thanks. On Monday, April 11, 2016 3:40 PM, Simon Slavin wrote: On 11 Apr 2016, at 8:32pm, Jose I. Cabrera wrote

[sqlite] Last time analyze was ran

2016-04-11 Thread Jose I. Cabrera
Just resending, as I didn't see a post for this one. Thanks. On Monday, April 11, 2016 12:20 PM, Jose I. Cabrera wrote: Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try

[sqlite] Last time analyze was ran

2016-04-11 Thread Jose I. Cabrera
Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try to find the answer, but there were none that showed anything regarding the question. So, I thought to ask the gurus. Thanks.

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

2015-10-14 Thread jose i cabrera
Thanks. Works great! Thanks. From: Richard Hipp Sent: Wednesday, October 14, 2015 5:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located On 10/14/15, jose isaias cabrera wrote: > -Original

[sqlite] PRAGMA cache_size and ATTACHED DBs

2015-08-24 Thread jose i cabrera
thanks. On 8/24/2015 1:34 PM, R.Smith wrote: > The cache size pragma dictates to (and affects) the connection, not > the DB. > > So yes. > > > On 2015-08-24 07:30 PM, jose i cabrera wrote: >> >> Greetings! >> >> When connecting to a DB, and setting

[sqlite] PRAGMA cache_size and ATTACHED DBs

2015-08-24 Thread jose i cabrera
Greetings! When connecting to a DB, and setting a PRAGMA cache_size, will the attached DB also respond/behave the same way/size set by the original connection? Thanks. jos?

[sqlite] Trigger help or how to update id based on column content

2015-02-18 Thread Jose I. Cabrera
Greetings! I have this table CREATE TABLE LSOpenJobs ( id integer primary key, ProjID integer, PSubClass, lang, ProjFund, RateType ); Imagine this set of records... 171421|132959|DOC-Trans|DE-DE|860.69|PER-WORD 171422|132959|DOC-Trans|ES-LA|624.96|PER-WORD

[sqlite] Trigger help or how to update id based on column content

2015-02-18 Thread jose i cabrera
On 2/18/2015 6:48 PM, Igor Tandetnik wrote: > On 2/18/2015 5:10 PM, jose i cabrera wrote: >> So, in reality, all the tasks of the project of >> like "lang" minus the PM, have to be added and 10% of that total be >> calculated to the (on this instance) DE-DE PM

[sqlite] Trigger help or how to update id based on column content

2015-02-18 Thread jose i cabrera
On 2/18/2015 4:37 PM, Igor Tandetnik wrote: > On 2/18/2015 4:19 PM, jose i cabrera wrote: >> I need to know what the percentage for this specific project ID, 132959, >> and language is going to be calculated. This may be different depending >> on the project. So, it may be

[sqlite] Trigger help or how to update id based on column content

2015-02-18 Thread jose i cabrera
On 2/18/2015 3:59 PM, Igor Tandetnik wrote: > On 2/18/2015 2:36 PM, Jose I. Cabrera wrote: >> these are my two steps: >> 1. SELECT RateType FROM LSOpenJobs WHERE ProjID=132959 AND >> PSubClass='PM' AND lang='DE-DE'; > > What is the point of this step? I don't see whe

Re: [sqlite] adding two tables together

2015-01-22 Thread Jose I. Cabrera
Thanks, Igor. On Thursday, January 22, 2015 4:23 PM, Igor Tandetnik <i...@tandetnik.org> wrote: On 1/22/2015 4:05 PM, Jose I. Cabrera wrote: >  imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create >table t1 (a,b,c,de,e,f);insert into t1 values

[sqlite] adding two tables together

2015-01-22 Thread Jose I. Cabrera
imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from t0));Error: table t1 has 6 columns but 4 values were supplied What I would like is to add t0 to t1 so that t1 now hasa|b|c|d|e|f What would be