Autore Topic: Nuovo driver del database sqlite3  (Letto 276 volte)

Offline vuott

  • Moderatore globale
  • Senatore Gambero
  • *****
  • Post: 11.331
  • Ne mors quidem nos iunget
    • Mostra profilo
Nuovo driver del database sqlite3
« il: 30 Marzo 2015, 02:03:11 »
Riporto questo messaggio di Minisini:


" Hi,

I have rewritten the sqlite3 database driver, so that I get rid of all
that badly written brain-fucking C++ code.

Now everything is written in C and smaller (about 3000 lines of code
instead of 6000). Less memory should be used by big results, and so
things should be a little bit faster. But I didn't do any benchmark.

Please report if you have any bug or crash with that new driver.

Note that I use it daily on my machine for my job, so I will be the
first one impacted by any mistake!

By the way, if you are looking for optimizations when reading a result
(whatever the database you are using), don't access them by field name,
but try to use field indexes.

I.e. Result[0], Result[1]... instead of Result["field name"].

Because Result["field name"] implies string comparisons with all result
field names to find the field index.

Regards,

--
Benoît Minisini
"
« Chiunque, non ricorrendo lo stato di necessità, nel proprio progetto Gambas fa uso delle istruzioni Shell o Exec, è punito con la sanzione pecuniaria da euro 20,00 a euro 60,00. »