[cfe-dev] Announcing Crange

[Renato Golin]

On 9 May 2014 15:36, Tobias Grosser <tobias at grosser.es> wrote:
>         - I wonder how quick querying the database is. In fact,
>           if those queries are quick (less than 50ms) even for big
>           databases, this would extremely interesting as you could in
>           an editor for example add missing includes as you type.

I don't expect the db to be the bottleneck here. If you plan your
table reasonably well (and this usage is *very* simple for a
relational database), queries should return results in milliseconds
for almost all queries, including inserts and updates.

However, during the parse, because you'll be listing all
relationships, if you insert one at a time, preparing the queries will
amount to a significant portion of the run-time. There are ways of
inserting blocks of data on the same query that you might consider, or
even creating a CSV and importing (MySQL could do that, not sure about
SQLite).

But after the database is set up, updating and selecting will be trivial.

cheers,
--renato