Source language: Translate to:

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

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

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

Postby christian » Fri Jul 27, 2007 3:50 am

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
User avatar
christian
 
Posts: 39
Joined: Sat Apr 02, 2005 9:25 am
Location: Germany

Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest

cron