Is there anybody with experiences with sqlite?

I'll make some questions assuming "yes" of the one above :)

Is its "query" performance comparable to db like postgresql or mysql?

Since it can be embedded, could it be possible to speed up the DBF
import? ( that is avoid DBF -> TEXT -> SQL )

Is there anybody who has already done an interface like
contrib/hbpgsql for sqlite?

I'm evaluating sqlite to "provide SQL interface to DBFs" for small
offices where the maintenance of a SQL server could be problematic.

The main requirement is IMPORT SPEED since near 10GB of DBFs need to
be imported, indexed and pre-calculated in 1-2 hours and QUERY SPEED
since there is nothing worse than wait more than 3secs for a web page.

best regards,
Lorenzo
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to