Page 1 of 1
TMyTable/TMyQuery
Posted: Mon 24 Jul 2006 20:45
by FerCastro
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.
Posted: Mon 24 Jul 2006 22:16
by GEswin
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.
Posted: Mon 24 Jul 2006 23:10
by FerCastro
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,
Posted: Tue 25 Jul 2006 00:56
by teunis
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