Search found 17 matches

Hmmm, Ive run into a bug in the table setup for 'pwdata'. I mentioned before that Im reserving the 'pwdata' setup in the main database for other systems that use it, but one of its features is intere ...

Hmmm, Ive run into a bug in the table setup for 'pwdata'. I mentioned before that Im reserving the 'pwdata' setup in the main database for other systems that use it, but one of its features is intere ...

Have you done any performance measures on the ATTACH command ?

Not yet, I am currently designing my database set-up. Once it is executable I will put up a test server and log in with various chara ...

PrC is using a later version with their setup, you might consider using that version. Makes compatibility between major systems easier Smile

But good luck in your project! Its good to see people sti ...

Common use would be to Commit, then immediately open a new transaction. A few minutes later Commit again, then open a new one.

That way you can take advantage of the speed of SQLite running with t ...

You can create multiple tables within the SQLite database, you don't have to use just the pwdata table. Those tables can also be different formats if you use the sql direct commands instead of just S ...

Common practice with servers using SQLite is to manually close the transaction every few minutes then start another one.

And nice work Smile

I couldnt have even touched this functionality without y ...

SQLite only supports a single transaction so parts 3-4 are irrelevant Smile

So a single expression such as:

SQLExecDirect("BEGIN TRANSACTION;");

Will create an open transaction ...

Nope, but when you make a new database with the utility you either have to use the correct .exe or you have to use another utility that creates it at the correct version.

Then I guess I better incl ...

Great! Please keep in mind that SQLite gets relatively slow if it has to work without an open transaction. If you do not BEGIN somewhere later on, every write operation is immediately written to the d ...

you could send a commit as the first query to the database then wrap the rest in transaction(s).

Holy crackers Tenkawa, its not only working, but its doing more then I thought it would. I call a C ...

According to what I just read in the latest source the behaviour is still there.

in sqlite.cpp

in the Connect function

rc = sqlite3_prepare(sdb, "BEGIN", -1, &pStmt, NULL);

...

It is because if you use the sqlite plugin straight from code in nwnx the entire session is one big transaction
if you look at the code it does a begin when it opens the database and ends the transac ...

I don't know anyone that is using Attach() with NWNX...

Any particular reason you aren't just using the tables in one database?

Even if I could implement my design in one database, that doesnt e ...

Okay I have extra databases ready made for NWNX and SQLite to access and modify. The question I have now is about the ATTACH command. In SQL syntax "ATTACH database-filename AS database-name&qu ...

The NWNX Community Forum