Which one is best performance?

[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 :)

[Dilip Krishnan]

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

Khaled Atta wrote:

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 :)

--
Regards,
Dilip Krishnan
MCAD, MCSD.net
dilipdotnet at apdiya dot com

[Bonj]

I think that's extremely wishful thinking
"Dilip Krishnan" <[e-mail]> wrote in message
news:uG****************@TK2MSFTNGP11.phx.gbl...

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

Khaled Atta wrote:

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 :)

--
Regards,
Dilip Krishnan
MCAD, MCSD.net
dilipdotnet at apdiya dot com