[sqlite] 64bit DLL vs 32bit

[jic...@barrioinvi.net]

On 2016-05-07 01:29, Simon Slavin wrote:

> On 7 May 2016, at 3:28am, Keith Medcalf  wrote:
> 
>> I presume you mean that running 32-bit application on a 64-bit OS is 
>> slower than the same application run on a 32-bit OS.
> 
> Hold on.  The original poster was talking about using a 32-bit DLL, not 
> a 32-bit application.  I don't know what Windows' limitations are.  n 
> 64-bit windows can you run a 64-bit application which uses a 32-bit DLL 
> ?  Or does the fact that the application uses a 32-bit DLL mean that it 
> must be 32-bit itself ?
> 
> Either way, what I found is that 32-bit apps run at expected speed if 
> they're just doing stuff internally.  The delays come when you meet a 
> 32/64 interface, for example if a 32-bit application is constantly 
> fetching data from a 64-bit source supplied by the 64-bit OS.
> 

Sorry for the late reply...

Well, I can not use the SQLite 64bit DLL in a 64bit environment with a 
32bit application.  So, this answer your questions, at least as SQLite 
DLL is concerned.  What I am trying to find out is the speed difference 
from both 32bit and 64bit environment.  I will have to look deeper, but, 
there are definitely differences.  I will come back later and let you 
know the outcome, if I can find it.  Thanks for your support.

jos?

[sqlite] Sorting by month with two dates input

[jic]

Greetings!

I have to create some reporting and I need to report on customers amount1 
and amount2 two based on the whole year of 2013.  There are two dates that 
are to be used as input: billdate and bdate.  I can do one or the other, 
but, I can not seem to get the correct date when using both.  The criteria 
is that if there is a billdate, that overides the bdate, so the billdate 
should be the one used and reported on.  If there is no billdate, then, 
bdate is used.  There is always a bdate as this is the date the project was 
opened, so all projects have a bdate.  But, not all projects may have a 
billdate. This is what I am trying...


SELECT cust, sum(ProjFund), sum(Xtra8), coalesce(billdate,bdate) as t FROM 
LSOpenProjects WHERE billdate BETWEEN '2013-01-01' AND '2013-12-31' OR bdate 
BETWEEN '2013-01-01' AND '2013-12-31' GROUP BY substr(t,1,7), cust;


But this is not working correctly, as the beginning of the result, there is 
no number because billdate is empty.  So, I get a list like this:


Co01|13016.16|20024.46|
Co02|12280.0|110.0|
Co03|550.0|0.0|
Co04|1317.49|285.72|
Co05|747.0|0.0|
Co05|187330.3|39076.85|
Co07|14148.39|0.0|
Co08|156011.68|6725.09|
Co09|10890.92|142.98|
Co10|333.34|0.0|
Co11|294.39|214.29|
Co12|14857.29|0.0|
Co02|402.16|522.28|2012-02-15
Co04|3506.5|3976.11|2013-01-15
Co05|270.29|351.03|2013-01-15
Co06|1273.17|0.0|2013-01-15
Co10|16337.75|21217.83|2013-01-15

but there should always be a date.  Any help would be greatly appreciated. 
Thanks.


josé 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance issue with JOIN and large IN operator

[jic]

"Richard Hipp" wrote...


On Wed, May 1, 2013 at 11:24 AM, Richard Hipp  wrote:




On Wed, May 1, 2013 at 8:30 AM, Martin Altmayer <
martin.altma...@googlemail.com> wrote:


Hi,

I have a query that runs more than 400x slower in 3.7.16.2 than in 
3.7.11.




This seems to be caused by the use of transitive constraints in version
3.7.16.  Your work-around (until an official fix is available in SQLite) 
is

to put a "+" sign in front of the "elements.id" identifier in the ON
clause:

  SELECT count(*) FROM elements JOIN tags ON +elements.id =
tags.element_id

WHERE elements.id IN ();

Thank you for the trouble report.



I think the problem is fixed with 
http://www.sqlite.org/src/info/faedaeace9


Dr. Hipp,

will this fix break the work-around you provided,
"
to put a "+" sign in front of the "elements.id" identifier in the ON clause:

 SELECT count(*) FROM elements JOIN tags ON +elements.id = tags.element_id
   WHERE elements.id IN ();
"
or will it also work?

Thanks. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.7.16.2

[jic]

"Stephen Chrzanowski" wrote...

For the fifth time.  ;)


It's probably more like 6th or 7th. He he he he...


On Sun, Apr 14, 2013 at 2:28 PM, jic <cabr...@wrc.xerox.com> wrote:


"Roger Binns" wrote...


 -BEGIN PGP SIGNED MESSAGE-

Hash: SHA1

On 13/04/13 14:55, jose isaias cabrera wrote:


Can this problem also from a DB file shared via Windows Shared folder



An effective way to corrupt your data is to use a networked filesystem.
They do not provide the exact required semantics as a local filesystem
provides.  Most of the time you'll get away with it, but every now and
then you'll experience data corruption.

Then like so many before you'll post to this mailing list, where you'll 
be

pointed at the following two links :-)

 http://www.sqlite.org/faq.**html#q5 <http://www.sqlite.org/faq.html#q5>

http://www.sqlite.org/**howtocorrupt.html<http://www.sqlite.org/howtocorrupt.html> 
(section 2.1)




Yeah, yeah, yeah... you said the same thing the last time I asked the 
same

question... :-)
__**_
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.7.16.2

[jic]

"Roger Binns" wrote...


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 13/04/13 14:55, jose isaias cabrera wrote:

Can this problem also from a DB file shared via Windows Shared folder


An effective way to corrupt your data is to use a networked filesystem.
They do not provide the exact required semantics as a local filesystem
provides.  Most of the time you'll get away with it, but every now and
then you'll experience data corruption.

Then like so many before you'll post to this mailing list, where you'll be
pointed at the following two links :-)

 http://www.sqlite.org/faq.html#q5
 http://www.sqlite.org/howtocorrupt.html  (section 2.1)


Yeah, yeah, yeah... you said the same thing the last time I asked the same 
question... :-) 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Informal question

[jic]

"Simon Slavin" asked...


Although there are many hobbyist programmers here, many of us are clearly 
using SQLite
for our serious day jobs, and not just for playing with.  So why is this 
list busy over the

weekends rather than during the working week ?


We are putting in place what we got over the weekend. :-) 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users