TMyTable/TMyQuery

FerCastro · Post by **FerCastro** » Mon 24 Jul 2006 20:45

Hello:

Does anybody can tell me the adventages and disadventages of using TMyQuery and TMyTable?

I am starting with myDac and I want to know it.

Thanks in advance

Fernando Castro
México, D.F.

GEswin · Post by **GEswin** » Mon 24 Jul 2006 22:16

Search a litle bit in this forum , advantages are a lot.. Imagine a table with 10.000 records.. and you only need some of them.. TTable will fetch all (Inncesary traffic over lan/wan, increases pc memory use, loads mysql etc).. with TMyQuery you only select what you need, faster, less memory, less traffic.. this plus other advantages like doing join's, union, etc.

FerCastro · Post by **FerCastro** » Mon 24 Jul 2006 23:10

GEswin, thanks for your answer.

And what is the best for a Grid? i mean, is more convenient make the relation of the datasource to a Table or a Query?

Please forgive this silly questions.

Regards,

teunis · Post by **teunis** » Tue 25 Jul 2006 00:56

Use the Query in the "dataset" property of a DataSource
and use the dataSource in the property "datasource" of the Grid
TMyTable is only usefull for small tables or for tables in a local database
As soon as you want to access the database over the INTERNET the tables should
be really small < 1 MB