[sqlite] Problems Getting Started

I'm using SQLite version 3.4.2 and for some reason, I cannot read from any SQLite databases. When I create the database, all the create and insert statements execute with no problems, and by using SQLite Database Browser, I can see that the tables are there and that they are populated. However,

Re: [sqlite] Problems Getting Started

with long file names? On 8/21/07, John Stanton <[EMAIL PROTECTED]> wrote: > > PokerAce wrote: > > I'm using SQLite version 3.4.2 and for some reason, I cannot read from > any > > SQLite databases. > > > > When I create the database, all the create and insert

Re: [sqlite] Problems Getting Started

I guess I should've stepped through again. Since having the initial problem, I added addition code, one of which caused the filename to be an empty string just prior to calling the function. It's working now. Sorry about that and thanks for the help. On 8/21/07, PokerAce <[EMAIL PROTEC

[sqlite] Debug Build Works, Release Doesn't

I'm using version 3.5.2. I built the static library using MSVC++ 6. The debug build works great. However, when I use the release build, the connect works, but every SQL statement I try to execute returns "SQL logic error or missing database." I know it's not a configuration problem between the

Re: [sqlite] SQLite and Large Databases

BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > PokerAce wrote: > > Initially, the memory usage > > was outrageous (~ 500 mb for a 1.3 gb db), > > How are you measuring memory usage? You have to be very careful as most > operating system tools will report a number greater

Re: [sqlite] SQLite and Large Databases

w.pokertracker3.com On Nov 8, 2007 11:59 AM, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- PokerAce <[EMAIL PROTECTED]> wrote: > > I'm trying to see if SQLite is suitable for large databases ( > 1 gb, > > millions of rows in each of several tables). Initially, the memory >

Re: [sqlite] SQLite and Large Databases

If you have to set that manually, it was not set. I am using version 3.5.2. I am doing tens of thousands of transactions, each without ~30 separate INSERTs. On Nov 8, 2007 11:40 AM, <[EMAIL PROTECTED]> wrote: > PokerAce <[EMAIL PROTECTED]> wrote: > > I'm trying to see

[sqlite] SQLite and Large Databases

I'm trying to see if SQLite is suitable for large databases ( > 1 gb, millions of rows in each of several tables). Initially, the memory usage was outrageous (~ 500 mb for a 1.3 gb db), but I got that down to < 30 mb by setting the cache size to 0 and setting a low soft heap limit. That works

Re: [sqlite] SQLite and Large Databases

Actually, I am. I abstract the database communication in my application, but I access each database using their native API. On Nov 8, 2007 12:44 PM, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- PokerAce <[EMAIL PROTECTED]> wrote: > > "Are you certain it's sqlite RAM