Which one is best performance?

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

re: Which one is best performance?

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:
[color=blue]
> 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 :)[/color]

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

re: Which one is best performance?

I think that's extremely wishful thinking


"Dilip Krishnan" <dilipdotnet..NOSPAM..@apdiya.com> wrote in message
news:uG%23c3XMGEHA.1012@TK2MSFTNGP11.phx.gbl...[color=blue]
> 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:
>[color=green]
> > 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 :)[/color]
>
> --
> Regards,
> Dilip Krishnan
> MCAD, MCSD.net
> dilipdotnet at apdiya dot com[/color]