Thank you Mr. Burstein. This is great !!! Run times using memory for DB and Temp are much improved over SSD - let alone conventional disk, "out of memory" messages are gone, count (*) is sub-second.
Time to go shopping for more RAM. Thanks again. On Mon, Apr 30, 2012 at 9:23 AM, Baruch Burstein <bmburst...@gmail.com>wrote: > I haven't tested it (I only have a 32-bit system), but here you go. Just > change the extension to .exe > > On Mon, Apr 30, 2012 at 4:28 PM, Udi Karni <uka...@gmail.com> wrote: > > > Dear Sqlite development team, > > > > I'd like to add a vote for requesting a 64-bit precompiled command-line > > shell binary (sqlite3.exe) for Windows 7 - to be added to the list of > files > > downloadable from the page <http://www.sqlite.org/download.html> . > > > > It would be very helpful for those of us who are not versed with > compiling > > C++ code. > > > > I have seen a tremendous performance boost from the use of "memory > > temp_store" and "memory database". The 64-bit version would allow them to > > go beyond 2GB. > > > > Is that simple? Not so simple? If you could elaborate - it would be much > > appreciated. > > > > Thank you ! > > > > Udi > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Programming today is a race between software engineers striving to build > bigger and better idiot-proof programs, and the Universe trying to produce > bigger and better idiots. So far, the Universe is winning. - Rich Cook > > _______________________________________________ > 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