Which one is best performance?

  • Thread starter Thread starter Khaled Atta
  • Start date Start date
K

Khaled Atta

Hi every body
Well lets assume that we are making a windows application project
and I have a datagird which will contain some data
1) well I can make a command object and give it a query in C# and
execute this command so that the datagrid gets its data.
2) and I can make a Query in the MS Access 2003 for example and I can
execute this query from the C#
Which one of those two methods will have better performance Execute a
query from the C# or call a query from the Access dataBase?
Thank you very much :)
 
I would'nt know if the query object in Access is "pre-compiled" but if
it is then that would be the better performer. You could try preparing
the sql statement in a command object aswell
Hope that helps
 
I think that's extremely wishful thinking


Dilip Krishnan said:
I would'nt know if the query object in Access is "pre-compiled" but if
it is then that would be the better performer. You could try preparing
the sql statement in a command object aswell
Hope that helps



--
Regards,
Dilip Krishnan
MCAD, MCSD.net
dilipdotnet at apdiya dot com
Click to expand...
 
Back
Top