Page 1 of 1

Opening tables with a lot of records (SQL-databases)

PostPosted: Fri Jul 27, 2007 3:50 am
by christian
Hello!

Using SQL-database with tables which contain a lot of records (tested with 600.000) never use "dbpOpenTable", because this command loads the whole table into memory, so after some long minutes (using 1 GB memory or more) NB says "Cannot open database XXX".

Use instead the command "dbpExecSQL" to select some records to a "temp"-table.

Works fine!
Christian