Problems populating large tables

digdagdigedag · Post by **digdagdigedag** » Wed 18 Apr 2007 11:20

hello everybody,

i am trying to populate a large table by repeatedly using the methods Append and Post of TMyTable.
after exceeding a certain table size, my program crashes due to memroy problems. is there any way to write large tables to the database without keeping all records in memory ?
thanks
uwe

Antaeus · Post by **Antaeus** » Thu 19 Apr 2007 09:30

Try to use the TMyLoader component. It lets you to fast load huge amount of data. Take a look at the Loader demo that is a part of MyDACDemo.
Another way is to execute INSERT statement repeatedly with TMyQuery or TMyCommand.