Re: [sqlite] Storing precompiled queries/vm?

[D. Richard Hipp]

Keith Herold wrote:
3.0 supports precompiled queries natively; is it possible to store the vm in
a resource dll or something, load it up when the application starts, and
then attach an open sqlite db to the stored vm? 

No.
The compiler in SQLite is very efficient.  It is likely that it would
take more time to read a prepared query from the disk than it would to
just recompile it.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

[sqlite] Storing precompiled queries/vm?

[Keith Herold]

3.0 supports precompiled queries natively; is it possible to store the vm in
a resource dll or something, load it up when the application starts, and
then attach an open sqlite db to the stored vm?  My impression was no, based
on the API and the lack of information on wiki and the mailing list about
it.

--Keith

**
- Sounds like a Wookie; acts like mad cow.

- I'm not a professional; I just get paid to do this.

- Rules for programming:
   1.  Get it working, right?
   2.  Get it working right.

- Things I've learned about multithreaded programming:

123...   PPArrvooottieedcc ttm  ueelvvteeirrtyyhtt
rhheiianndgge  dwi hnpi rctohhg eri aslm omscitanalgt 
 iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd  'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
**