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
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:
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
"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
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
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
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
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
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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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
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.
-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
15 matches
Mail list logo