[sqlite] sqlite3_profile() not working with SQLite 3.6.10

[manohar s]

Hi,
 I am trying to profile queries on a database of size 2 GB, but the code
inside callback is not executing.

Here is the snippet:

    ret = sqlite3_open("before_vacuum.data", &vSqlite);

    if(ret != SQLITE_OK)
        printf("error in opening sqlite database file!\n");

    ret = sqlite3_prepare(vSqlite, query, strlen(query),
                          &stmt,(const char **)&unused);

    if(ret != SQLITE_OK)
        printf("preparing SQLite query failed\n");

    sqlite3_profile(vSqlite, xProfile, NULL);

    ret = sqlite3_step(stmt);

    if(ret != SQLITE_DONE && ret != SQLITE_ROW)
    {
        if(ret == SQLITE_ERROR)
            printf("error in executing the query!\n");
    }

and callback:

void xProfile(void * pArg, const char * pQuery, sqlite3_uint64 pTimeTaken)
{
    printf("%s", pQuery);                    // It never executes here
    printf("%I64d", pTimeTaken);
}

I downloaded the latest source code and compiled it as a static library.

1) Am I doing something wrong here? [I couldnt find even a single sample
source or snippet regarding this :( ]
2) Do I need to take care of any compilation option while building SQLite?

Waiting for answers,
Manohar.S

hope is the only thing which keeps us all happy
http://sqlyog.wordpress.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users