Re: [sqlite] List manager webpage unavailible.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/06/12 14:17, Werner Smit wrote: > The List manager webpage cannot be loaded at the moment. > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users (as > specified at the bottom of every mail) It may be because port 8080 is blocked for

Re: [sqlite] List manager webpage unavailible.

On 7 Jun 2012, at 10:17pm, "Werner Smit" wrote: > The List manager webpage cannot be loaded at the moment. > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Link works for me. Possibly has been fixed since your post. Please try again. Simon.

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

There was a significant increase in throughput converting the sqlite3_exec inserts into prepared statements: I suspect every previous insert was compiling versus now only 1 of every 10,000 inserts. I'll bump this up to 100K next revision I've changed many variables so its hard to base line the

[sqlite] List manager webpage unavailible.

The List manager webpage cannot be loaded at the moment. http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users (as specified at the bottom of every mail) How can I change my subscription parameters without going there? In the old days you could send a blank email to a mailing list, and

[sqlite] FTS4 Questions

I'm testing out the capabilites of fts4 virtual tables. First question concerns the snippet() function. Unless I'm doing something wrong, it appears snippet() only returns one snippet of text containing the requested string from each row in the table irrespective of how many instances of the

[sqlite] (no subject)

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

Re: [sqlite] Running SQLite Test Suites

On Thu, Jun 7, 2012 at 11:51 AM, Carl Desautels < carlin.desaut...@senecacollege.ca> wrote: > Hi, > > A partner and I have downloaded the SQLite core source and made some > alterations, and we can successfully build the source. > However we would like to know how to run the TCL test suite,

[sqlite] Running SQLite Test Suites

Hi, A partner and I have downloaded the SQLite core source and made some alterations, and we can successfully build the source. However we would like to know how to run the TCL test suite, resources online suggest simply running $make test/alltest.I feel like this resource is out of date because

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

It shouldn't. It's the same as calling it with NULL, 0, NULL. According to the docs, that should execute fine, even if an error occurs. Now, if NULL != 0 on this system, it's different, but I doubt that's the case. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

On 7 Jun 2012, at 2:24pm, IQuant wrote: > Looking through the code I noticed sqlite3_exec(db, zSQL, 0, 0, 0); > wrapped inside transaction. > Suspect this is causing the CPU load, going to try recoding using > prepared statements. There's nothing wrong with sqlite3_exec

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

There's some good info here. http://www.brianmadden.com/forums/t/30061.aspx Namely, use 1 CPU per VM and do more VMs. Addresses your 100% usage directly. And what does process explorer tell you about context switches? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced

Re: [sqlite] SQLite3.dll for OS x64

"didn't work" doesn't tell us much. What OS are you using? What compiler are you using? What error are you seeing and what do you expect to see? What code are you testing? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

ESXI 5 Disk is on a local host, running raid 6 on a LSI raid card Machine has HT turned off so only scheduling full cores System takes up less than 500mb of RAM and uses less than 1% of CPU Intel Xeon X5482 3.2Ghz 64GB RAM 6TB Raid 6 10GB NIC VMXNET NIC#2 Windows Server 2008 R2 Dedicated

Re: [sqlite] SQLite3.dll for OS x64

I download source fro office site. rebild it to the x64. But sqlite3.dll not work. If many code rewrite for work for x64 pleace say where i can download. or say where i can read manual for recognize. -- View this message in context:

Re: [sqlite] how to show image

On Thu, 7 Jun 2012 02:10:44 +, YAN HONG YE wrote: > >sqlite3_exec(db,"create table image (filename varchar(128) unique,img >blob);",0,0,); >and put image to my sqlite db: >sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); > >I export the html