[sqlite] sqlite performance issues on Linux running on MIPS (BIG ENDIAN)

2009-05-02 Thread chandan r
Hi, I am planning to use sqlite in an application program. The application will be running in Linux environment on MIPS processor (BIG ENDIAN). Are there any sqlite performance issues when running on MIPS processor with Linux as the OS. In particular are there any issues regarding non-aligned

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread John Stanton
I built and use an application server which embeds Sqlite and processes web traffic. It is multi-threaded and can handle very many connections. It is very fast because it uses no IPC channels or process creation. It caches threads and reuses them rather than creating and killing them. It

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread Christian Smith
James Mills uttered: Hi Richard, When I mean high-traffic I would imagine more than 1 hit/s. I do want to clear something up though (if you could): If a site using sqlite takes 700ms to load and there are two simultaneous (as simultaneous as one can get) hits to the site, say user A and user

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread James Mills
Hrmm also a couple of other things... In order to make a decision, I would need some way of running tests and simulations so I can come up with some numbers. Then scale that up and use it as an indicator for our decision. Do you have any tools that'll help with this ? cheers James -- --

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread James Mills
Hi Richard, I appreciate your feedback on the matter. I myself have used SQLite in many of my applications in the past for quite some years now. Most of them do indeed only write to or read from teh database for only fractions of a second. When I mean high-traffic I would imagine more than 1

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread drh
James Mills <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I'm wanting to use SQLite in an embedded web application > that will serve as a proxy and possible serve up many > connections at once. I'm talking here of high-traffic > through this web app. > > Question is, how will SQLite perform under

[sqlite] SQLite Performance Issues

2006-10-22 Thread James Mills
Hi Folks, I'm wanting to use SQLite in an embedded web application that will serve as a proxy and possible serve up many connections at once. I'm talking here of high-traffic through this web app. Question is, how will SQLite perform under these kinds of conditions ? I've been speaking to a few