verytime I increase the where clause with one more expression, I see the
number of rows get halved.
My emphasis was to reduce the number of rows being traversed to execute this
query.
Is this normal? Or did I interpret it totally wrong? I shall appreciate yo
Offlate I have observed a strange behavior with Query Optimizer. I am not
sure if it is the desired behavior, yet please find my observations below:
Table
employee_table
---
id nameage se
k and suggestions.
Regards,
-Akbar Syed
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
connection. As of
now I am using 500K of default cache for each open connection
with 100K for attached connections and 500k default temp-cache and
also I have temp-store set to a file. It might hamper my
performance, yet I dont have any other option thou.
Regards,
-Akbar
On 26 Mar 2010, at 10:47am
the primary index but on some other
column of type TEXT. Do u think this will slow down the things?
Regards,
-Akbar
On Thu, Mar 25, 2010 at 05:22:04PM +0100, Akbar Syed scratched on the wall:
>* I have been trying to improve the performance and memory usage for my
*>* application whereby i ha
I have been trying to improve the performance and memory usage for my
application whereby i have maximum of 30 databases attached. In total I have
31 databases with 30 databases attached to the first one. Each database has
a single table with approx 65 columns and the records in each table may go
u
I have been experiencing a strange issue with savepoint error for the
library version 3.6.22.
I have the following code:
char* sql = "SAVEPOINT sp;";
char* err;
slim_int ret = sqlite3_exec(sqlitehandle, sql, NULL, NULL, &err);
The ret is 1 which is SQLITE_ERROR
and err = "near \"sp\": syntax error
7 matches
Mail list logo