Devart Forums

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

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.