Am Donnerstag, den 22.09.2011, 20:28 +0100 schrieb Simon Slavin:
> Indexes are not recreated from scratch unless you explicitly ask for them to
> be (rare). If you open a database with a million rows in and add or change a
> row, the indexes for that table are each modified slightly to reflect
recreation only once, wouldn't it?
best regards
JM
Am Donnerstag, den 22.09.2011, 18:43 +0100 schrieb Simon Slavin:
> On 22 Sep 2011, at 5:30pm, Jay A. Kreibich wrote:
>
> > Indexes are updated automatically.
>
> As they are with all implementations of SQL. That&
e the index manually or will
the recreation of the index be handled automatically by sqlite?
I couldn't find this information in the sqlite documentation.
Regards
JM
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
Hello,
In a SELECT statement with multiple tables, is it possible to replace
WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses
(with the same criteria) for the same purpose (no cross join) ?
Are the two methods roughly equivalent in performance ?
We ask this because we won
Hello,
We try to port an application specialised in financial calculus written
in VBA + MS Access toward Tcl + Sqlite.
In this application, 90% of the calculus is directly processed at the
SQL level via INSERT/UPDATE statements executed against the db, and
subsets are calculated with INNER JOI
Hello,
In SQLite, it seems it's not possible to associate several tables in an
"update" statement.
Is there a workaround to execute this kind of SQL statement inSQLite :
"UPDATE VariablesPointages INNER JOIN Sociétés ON Sociétés.Mois =
VariablesPointages.Mois
SET VariablesPointages.CodSoc = S
6 matches
Mail list logo