Additionally, I and others have got the Cygwin64 compiler to build 64-bit on both SQLite3 and the math extensions. Not optional since, as far as I know I need to install Cygwin64 on each machine that I will have running this process. But one thing for Cygwin64 is that one of my colleagues got a 4x speed improvement, albeit changing a script from using a Ceil function (requires math lib) to a Round function (core function) for testing purposes. I need to test myself to see if it is truly that much an improvement, I am dubious.
Richard -----Original Message----- From: Rousselot, Richard A Sent: Saturday, August 13, 2016 10:40 AM To: SQLite mailing list Cc: Rousselot, Richard A Subject: RE: [sqlite] 64-bit SQLite3.exe Thanks, this does allow the library to load and process. The thing is your build is by far the slowest I have received, slower even than the 32-bit version. Could you tell me what version of SQLite you compiled, your compiler and the settings you used on each build? I plan on compiling all the settings and speed tests of the builds I have received and tried to build myself. It should be an interesting matrix. Richard -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Random Coder Sent: Friday, August 12, 2016 4:54 PM To: SQLite mailing list Subject: Re: [sqlite] 64-bit SQLite3.exe On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A <richard.a.rousse...@centurylink.com> wrote: > I, and others, have tried to compile this as a 64-bit library but it will not > load from the command line (using .load) and gives the "Error: The specified > module could not be found." > > Anyone have tips on how to resolve this? Is this library somehow > incompatible with 64-bit? Generally that means the exports haven't been properly setup. The easiest way to do this generally is to setup a .def file to get the proper function exported from the DLL with the correct naming convention. I've done just that for a quick test version at https://new-bucket-2a9cf983.s3.amazonaws.com/sqlite64.zip , which may or may not work for your needs. Other than verifying acos() was present, I've done no testing. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
