Re: SQL Query or View Object

From: SriSamp (ssampath_at_sct.co.in)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 16:02:14 +0530

I would go in for the view, because it can be secured. Ad-hoc SQL should be
avoided because it can tomorrow be difficult to maintain and change and also
will lead to performance issues. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:%23RIc0cXFEHA.3096@TK2MSFTNGP11.phx.gbl...
> Hi to ALL,
>
> If I want to get a set of records from Database in readonly mode (Ex. For
> Report or to Display in a Grid) Which of the Folowing is FASTER?
>
> 1) Use of SQL Statement in ADO Objects in READONLY Mode from The
Application
> Program.
> 2) Create a VIEW in Database Server for that SQL Query and Use that Query
> from Application Program in ADO in READONLY Mode.
>
> Please Suggest Which Way is Fater and Efficient Way to Retive data to view
> only and WHY (The Cause)?
>
> Thanks
> Prabhat
>
>

Relevant Pages

  • Re: SQL Query or View Object
    ... You are essentially going back to doing the AD-HOC SQL, ... WHERE clause, by using a UDF functions that return a table. ... > SQL QUERY from the Application Program? ... >> If I want to get a set of records from Database in readonly mode (Ex. ...
    (microsoft.public.sqlserver.programming)
  • Re: Equivalent of Get Next Extended to retrieve only unique keys?
    ... The only real "extra" stuff is pertaining to SQL query optimization. ... Bill Bach wrote: ... Retaining the ability to filter on multiple>> items would probably ...
    (comp.databases.btrieve)
  • Re: Setting a Default Value
    ... the make the Sql call from within Application_Start in Global.asax. ... the query string value each time I needed to ... going to assign the default value through a database query. ... run the following SQL query: select * from table where x = 1 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MultiSelect Property
    ... > For Each vItm In Me!lbSelectContract.ItemsSelected ... > Dim stCriteria As String ... >> SQL query). ... >> the multiselect list box appears in the SQL query. ...
    (microsoft.public.access.devtoolkits)
  • Re: Report in VBA - FilterName or WhereCondition
    ... strWhere clause as you advise. ... If you use un-bound controls in your sql query, ... strWhere in the filter parameter of the report, the defense is that you can ...
    (microsoft.public.access.modulesdaovba)