[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re: [Fastcgipp-users] FastCGI++ is indeed fast

From: ninti
Subject: Re: Re: [Fastcgipp-users] FastCGI++ is indeed fast
Date: Mon, 25 Jan 2010 17:10:21 +1030

I'm still a C++ newbie from the PHP-cut-and-paste-and-modify-til-it-works 
of programming. I tried a couple of Sqlite C++ libraries until finding sdsqlite 
which just worked: 
When I skill up enough I'd like to maybe plug Sqlite into Asql. The Sqlite API 
apparently not so difficult, but I struggle a bit with the documentation. 
Not sure if Sqlite loads db into memory, it appears to be basically a flat file 
type of db that understands a large subset of SQL commands. These pages suggest 
that Sqlite3 can be used as either an on-disk (default) or in-memory database: 
Some general info about why Sqlite can be fast: 
My Sqlite queries are done one after another using sdsqlite in a class 
instantiated inside response(). 
The results are stored in a struct which is then fed as a (reference) parameter 
to an HTML class instantiated inside response(). 
Methods called on the HTML class are then sent to out stream. 
> That's good to know. How exactly did you handle the sqlite query? I'm 
> just curious if running the queries asynchronously would make any 
> difference with sqlite. Do you know if sqlite load the entire database 
> in memory? If so then I would assume a synchronous query would actually 
> be fastest. 
> -- 
> Eddie Carle  

reply via email to

[Prev in Thread] Current Thread [Next in Thread]