Re: [sqlite] Sqlite Endianness

Subject: Re: [sqlite] Sqlite Endianness 2008/7/25 Dave Gierok <[EMAIL PROTECTED]>: > Does anyone know what endianness a Sqlite database is stored in? Or does > that depend on the endianness of the machine it was created on? I am > wondering because we ship a game that runs on Xbox

[sqlite] Sqlite Endianness

Does anyone know what endianness a Sqlite database is stored in? Or does that depend on the endianness of the machine it was created on? I am wondering because we ship a game that runs on Xbox 360, which uses the PowerPC architecture and has a different endianness than the PC. We run PC

[sqlite] RE: Crash in prepSelectStmt

Ahh, sorry about that stack. It's not actually a trashed call stack. The variables are not accurate here because it is an optimized build's call stack. The reason I included it was merely to show the function-call-stack, which is accurate. From: Dave Gierok

[sqlite] Crash in prepSelectStmt

I'm getting a very occational crash in prepSelectStmt when trying to run the following statement: CREATE TABLE tmpdb.[Profile0_Career_UnlockedCars] AS SELECT * FROM [Profile0_Career_UnlockedCars]; Where another tmpdb has been attached to the main db via ATTACH. My call stack is: *

RE: [sqlite] ATTACH and :memory: databases

into the 2nd one, it is still empty after this has been done. I think the first :memory: database might be attaching to, uh, itself. Is there a way to specify the name of a memory database uniquely? Something like ':memory:2'? Nothing that I've tried works. -Dave Gierok -Original Message

[sqlite] ATTACH and :memory: databases

I would like to attach a :memory: database to another :memory: database. How is this possible since the ATTACH command requires the database's file name? ATTACH [DATABASE] database-filename AS database-name -Dave Gierok

RE: RE: [sqlite] DROP INDEX not freeing up memory

: [sqlite] DROP INDEX not freeing up memory Do you have to drop the index? Why not just keep it around, its obviously useful if you need to create it in the first place right? Dave Gierok <[EMAIL PROTECTED]> wrote: It does in fact look like the memory isn't being freed up entirely. I am pr

RE: RE: [sqlite] DROP INDEX not freeing up memory

is quite a bit of memory in our world. Any suggestions or explanations? Thanks, Dave -Original Message- From: Dave Gierok [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:06 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] DROP INDEX not freeing up memory OK, thanks, I'll do

RE: [sqlite] DROP INDEX not freeing up memory

OK, thanks, I'll do some more digging and let you know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 8:30 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Dave Gierok <[EMAIL PROTECTED]>

RE: [sqlite] DROP INDEX not freeing up memory

allocated. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 16, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Dave Gierok wrote: > (I'm resending this, as I have not seen it posted the first time I s

[sqlite] DROP INDEX not freeing up memory

Hello, I am running an in-memory db and am using the functionality where we override all the OS calls such that we implement our own memory management and file IO. Therefore, I am able to easily track the amount of memory Sqlite is taking up. I have noticed that when I call CREATE INDEX and

RE: [sqlite] Is there a way to turn off -journal files?

all ears. Anyone know if this is possible? Thanks, Dave -Original Message- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Monday, January 15, 2007 12:42 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a way to turn off -journal files? On 1/15/07, Dave Gierok <[EM

RE: [sqlite] Sqlite DB file sizes

if this is the second time this was sent out. It appears as though the last time I sent this it did not make it out -- at least I never received the mail. Thank you very much, Dave Gierok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 5:12 PM

RE: [sqlite] Sqlite DB file sizes

How difficult would it be to change my version of Sqlite such that it uses 32-bit floats instead of doubles for REAL values in memory? Could you point me in the right direction? We are in a real shortage for RAM in our game. Thank you very much, Dave Gierok -Original Message- From

RE: [sqlite] Sqlite DB file sizes

? Thanks, Dave Gierok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 4:27 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite DB file sizes Dennis Cote <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > Dave

RE: [sqlite] Sqlite DB file sizes

ints instead of 64-bit ints. - Anything else that would reduce the size in memory? I previously asked about setting the cache size to do this but it appears that doesn't do anything for :memory: databases (which makes sense). Thanks, Dave Gierok -Original Message- From: [EMAIL PROTECTED

[sqlite] Sqlite DB file sizes

supports flexible types where different rows can change their types. If that's true, is there a way to turn this off at compile time or something? Or are there any other tricks to reduce the data size of the DB? Thanks, Dave Gierok

[sqlite] :memory: db and cache size

Does anyone know if :memory: databases still use a cache? We are using Sqlite in a game and are very tight on memory. I'm wondering if it would be good for us to reduce the cache size to 0 (or something very small), and if there would be any performance penalty for doing so. It seems like

RE: [sqlite] Memory DB: Load from file

//WHAT DO I DO NOW? //**** } Thanks, Dave Gierok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 05, 2006 12:49 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Memory DB: Load from file Andrew Pis

[sqlite] Memory DB: Load from file

, Dave Gierok