On 1/4/2013 8:40 AM, Krzysztof wrote:
BTW: About storing dictionary tables in memory. What is faster: - Load all "contries" table to memory and locate it locally (I'm using Free Pascal / Lazarus) - Create unique index on country name and select from countries table on each insert to customers
My guess is that loading all countries into memory up front would be faster, but either way the cost of inserting a row into Customers table is greater by an order or two of magnitude, and will dwarf any difference. So in the end, it wouldn't matter much. But if you want to be sure, measure it both ways.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
