Devart Forums

Sorry I can't find MyDacDemo
...........
I have 5 Apollo (XBaseTables) where a collection of data (related tables) is prepared.
MySQL has about 50'000 Records.
DataCollection should be loaded into 3 diffrent MySQL Tables.
Some Data are existing some not.
That means for some collection is only a update to do, for not existing create new records on MYSQL Tables.
......
I mean this to do with the Query component - is this OK ?
......
I recognized by test, that the memory on the client is increasing and increasing and one time the memory is overflowed......
What can I do for preventing this ?
....
(I have just ordered the Standard Version DACMysql - better the Professional ?
- need I the Loader ?? (I have seen in Forum Loader is faster...
Thanks Erich

Hello,

MyDACdemo is located in C:\Documents and Settings\All Users\Documents\Devart\\Demos\MyDacDemo on Windows Vista/7 or in \Demos\MyDacDemo on prior versions of Windows.

You can use TMyQuery for your task.

To avoid memory allocating on the client machine you should create SQL statements for Insert and Update operations instead of opening the dataset. In this case when you are inserting the new records in a table, the memory isn't allocated for them on the client machine.

You can see the difference between editions here: http://www.devart.com/mydac/editions.html
Also MyDAC Trial version includes all components, so you can try them. If they fit you, then you can upgrade Standard Edition to Professional Edition. You can find more information about upgrade here (in the Edition Upgrades chapter): http://www.devart.com/mydac/ordering.html

TMyLoader serves for fast loading of data to the server. You cannot use it for updating tables. Also, TMyLoader doesn't support simultaneous loading into multiple tables.