[sqlite] sqlite3_step() vs. get_tables() - CPU-Usage

Hello, I need some information about the sqlite3_step() function. How much CPU-usage does it need in comparison with sqlite3_get_tables()? I have to implement functions like next(), prev(), last(), first(), relative(int) and absolute(int). #1 Way - sqlite3_step() I can only step forward with

Re: [sqlite] starting with unicode

Mark Wyszomierski wrote: >strSql.Format(_T("SELECT * FROM test")); > >sqlite3_stmt *pStmt; >const char *pszTailPointer; >int nRetVal = sqlite3_prepare(db, strSql, strSql.GetLength(), > , ); >if (nRetVal != SQLITE_OK) { >TRACE("prepare fails!! [%i] [%s]\n",

Re: [sqlite] starting with unicode

Hi Nikki, Why do we want to use sqlite3_reset() in the for loop? If I leave it in, the loop keeps running forever since I guess it really does keep resetting the sql statement. Do we need it though inside the while loop when SQLITE_BUSY is returned though? Is that the proper way to try again

[sqlite] Re: sqlite3_step() vs. get_tables() - CPU-Usage

A. Klitzing <[EMAIL PROTECTED]> wrote: I need some information about the sqlite3_step() function. How much CPU-usage does it need in comparison with sqlite3_get_tables()? The same: sqlite3_get_table is implemented in terms of sqlite3_step. Note that sqlite3_get_table loads the whole resultset

Re: [sqlite] starting with unicode

Mark Wyszomierski wrote: John, Cory, thank you very much. I got execute plain statements ok by modifying my earlier posting a bit. I was able to create a table using the prepare statement. Previously I was using sqlite3_exec() to execute my statements and I could pass it a callback function

Re: [sqlite] starting with unicode

If you have no variables in your SQL (like SELECT * FROM ...) then you don't bind. If you have "SELECT * FROM junk WHERE name=?" then you need to bind like this. The bind is good until you do a reset. char that_name = "Harry"; ... rc = sqlite3_bind_text(xek, 1, that_name, -1,

Re: [sqlite] sqlite3_step() vs. get_tables() - CPU-Usage

A. Klitzing wrote: Hello, I need some information about the sqlite3_step() function. How much CPU-usage does it need in comparison with sqlite3_get_tables()? I have to implement functions like next(), prev(), last(), first(), relative(int) and absolute(int). #1 Way - sqlite3_step() I can

Re: [sqlite] starting with unicode

Mark Wyszomierski wrote: > Why do we want to use sqlite3_reset() in the for loop? If I leave it > in, the loop keeps running forever since I guess it really does keep > resetting the sql statement. Do we need it though inside the while > loop when SQLITE_BUSY is returned though? Is that the

[sqlite] Re: sqlite3_step() vs. get_tables() - CPU-Usage

Thanks, I think I will write my own 'cache' with sqlite3_step(). signature.asc Description: OpenPGP digital signature

[sqlite] Suggestion

Drh:thanks a lot for your great SQLite,I have a suggestion:3.37 add some more feature,I don't think every body need these,so for me I would like a release just fixs for 3.36 without new feature,what do you think about? thanks a lot!

[sqlite] indexing large sqlite db

Hello, I am building a very large (> 500M rows, ~6 GB) sqlite database that has three integer columns. I find that inserting all the rows takes only a couple hours, but when I try to create an index on any of the columns the process will run for days without finishing. If the entire operation

[sqlite] Building on SCO Open Server

Hi, I'm trying to build SQLite 3.3.7 on SCO Open Server 5.0.5. So far, I've installed gnu make (which was reasonably painless) to get around the limitations of the default SCO make. We don't have tcl installed, so I ran configure with the -disable-tcl option. I didn't get any warnings from

Re: [sqlite] indexing large sqlite db

--- Andrew McCollum <[EMAIL PROTECTED]> wrote: > I am building a very large (> 500M rows, ~6 GB) sqlite database that has > three integer columns. I find that inserting all the rows takes only a > couple hours, but when I try to create an index on any of the columns the > process will run for