But I still get orignal error message, a pice of code as follow, suppose all
routines open the same database:
void fillSchedule(void *param)
{
Open();
...
Close();
}
void fillCredits(void *param)
{
Open();
...
Close();
}
int main(void)
{
Open()
...
Close();
On Thu, 2007-01-18 at 11:21 -0800, mikpol wrote:
> Hi,
>
> I got a weid behavior while writing some triggers. It would be best to show
> it using an example. Basically, I have two tables A and B. When something is
> inserted into A, it is inserted into B with a trigger using the rowid of
> newly
You may find that adding backward pointers will allow you to do
deletions better.
Cesar Rodas wrote:
project called, PDBM.
The project is DBM like project, with a B+tree, and key -> value data,
similar to BDB, QDBM or GDBM.
For that project I need implement a Pager system.
As I understand a
Try recompiling with Intel C++ Compiler.
2007/1/19, A.J.Millan <[EMAIL PROTECTED]>:
Hi:
An application was running Ok under version 3.3.7. When recompiling with
v.
3.3.10, crashed at certain point in runtime. "invalid page in module
MSVCRT.DLL of 0167:780027a3".
The Sistem is running
On Fri, Jan 19, 2007 at 12:51:36AM +0100, Nemanja Corlija wrote:
> On 1/19/07, Nicolas Williams <[EMAIL PROTECTED]> wrote:
> >Why don't you use a trigger to duplicate INSERTs into the memory db to
> >the disk db?
> >
> Nicolas, thanks for the idea. Didn't really think of that.
>
> But in my
Hi:
An application was running Ok under version 3.3.7. When recompiling with
v.
3.3.10, crashed at certain point in runtime. "invalid page in module
MSVCRT.DLL of 0167:780027a3".
The Sistem is running MS Windows98 SE fully patched.
Msvcrt.dll is version 6.10.8924.0.
I compile with
Hi,
I got a weid behavior while writing some triggers. It would be best to show
it using an example. Basically, I have two tables A and B. When something is
inserted into A, it is inserted into B with a trigger using the rowid of
newly inserted row of A. However, if this id already exists in B,
Well, those extra 2MB sure would be nice when we go 'in-game'. We primarily
use Sqlite while we're 'in-UI' and when we transition to going in-game, we try
to free up as much memory as possible. Thus, our usage pattern of
creating/dropping the same indices over and over. We might be able to
On Jan 18, 2007, at 8:01 AM, [EMAIL PROTECTED] wrote:
I don't know what capability Applescript has. The easy way to do
it with a
script in the various Linux shell languages is with a "HERE"
document, where
the input to the command is redirected from the block of lines
which follows
the
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
properly tracking xMalloc, xRealloc, and
If you are using the OS to determine if memory is freed then perhaps that is
where the problem lies. Many operating systems do not return memory back to the
OS after a call to free. Instead the process will retain that in a "free pool"
for later re-allocation.
Ken
Dave Gierok <[EMAIL
Bill Hernandez <[EMAIL PROTECTED]> writes:
> I tried finding a pragma command for .headers on, but didn't have any luck.
>
> sqlite> .headers on | .mode column customers | select * from customers ;
> I also tried :
>
> sqlite> select * from customers ; < .headers off
>
> and that didn't work
I try an very long insert without BEGIN and COMMIT and this is very slow..
with a transaction is very very fast... just try and tell us the result
Gaurav
On 18/01/07, Ian Frosst <[EMAIL PROTECTED]> wrote:
It could be that there is no transaction block wrapped around the inserts
(a
BEGIN
It could be that there is no transaction block wrapped around the inserts (a
BEGIN TRANSACTION before the start of the insert loop, and a COMMIT
TRANSACTION at the end.) If there is no explicit transaction, then every
insert has an implied transaction, which considerably slows down the
database
On page 18 of the book "SQLite" by Chris Newman, he states "... it is
possible to pipe or redirect a series of commands to the program
rather than key them in"
I'm trying to get this to work using the shell, and cannot seem to do
it. Once I get it working then I can call them as shown
15 matches
Mail list logo
