VirtualTable and Create Temporary Table

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ghaith
Posts: 5
Joined: Wed 27 Feb 2008 13:08

VirtualTable and Create Temporary Table

Post by ghaith » Fri 14 Mar 2008 14:39

Hey,
I need to have some kind of temp tables in my application, should i've noticed the component TVirtualTable, as well as mysql's create temporary table, which one is the recommended way to use?

Thank you

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 14 Mar 2008 16:24

You should choose between temporary table of MySQL and TVirtualTable proceeding from tasks entrusted to this table.

The advantage of TVirtualTable is that it stores data on the client, therefore it does not need roundtrips to server when you need data in your application.

ghaith
Posts: 5
Joined: Wed 27 Feb 2008 13:08

Post by ghaith » Sat 15 Mar 2008 08:03

Thank you, that was very helpful

consider this thread solved

Post Reply