Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-23 Thread J Decker
CPU Core at 100% for entire test, x64 code is ~10% faster than x32 code. So; IO bound things 32/64 doesn't matter so much; but compute bound, through data already in memory gets significant improvments because of addtional general purpose registers and optimal calling conventions for things of few

Re: [sqlite] CREATE FUNCTION

2016-08-23 Thread Quan Yong Zhai
>From: Rousselot, Richard A >Sent: 2016年8月23日 22:14 >To: SQLite mailing list >Subject: Re: [sqlite] CREATE FUNCTION >Trust, me if I could remove that dumb message I would. :) There is no such thing as a dumb question. Packing all the core business logic in SQL language has some advantage, It’s

Re: [sqlite] CREATE FUNCTION

2016-08-23 Thread Rousselot, Richard A
Trust, me if I could remove that dumb message I would. :) Thanks to everyone for your answers. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Monday, August 22, 2016 2:39 PM To: sqlite-users@mailinglists.sqli