Re: Which one is best performance?

From: Bonj (a_at_b.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 19:51:22 +0100

I think that's extremely wishful thinking

"Dilip Krishnan" <dilipdotnet..NOSPAM..@apdiya.com> wrote in message
news:uG%23c3XMGEHA.1012@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

Relevant Pages

  • RE: How to execute a select statement inside an Event Procedure?
    ... I am trying to execute the follow command inside the control source property: ... The NonCompliance is a query-field that I request the information. ... The Month-Process-Compliance-2 is a query. ...
    (microsoft.public.access.formscoding)
  • Re: how compile sql
    ... >>The sql query always needs to be run ... Use the SQLCI PREPARE command to compile your query/stmt. ... Use the SQLCI EXECUTE command multiple times without recompiling. ...
    (comp.sys.tandem)
  • Re: NULL param for NOT NULL INT column fails execution
    ... > When i execute the above command with a NULL parameter, ... If you use ICommandWithParameters, your Execute ... The query plan for the ... possible that using the SQL Profiler to see what's sent to SQL Server ...
    (microsoft.public.data.oledb)
  • RE: insert using sqlparameters
    ... write the query & then use execute. ... //execute command ...
    (microsoft.public.dotnet.languages.csharp)
  • 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. ... the sql statement in a command object aswell ... > execute this command so that the datagrid gets its data. ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast