Re: MS Best Practice - Load subset of a single Row

Tech-Archive recommends: Fix windows errors by optimizing your registry

I meant - stay away from writing your own cursor.

Anyway, 100-200 columns in a table .. EEEEEEEEEEEEEEEEEEEE !!!!

But I'm gonna try and stay out of optimizing your database.

If you are sure that the query structure doesn't change too often, I say use
dynamic SQL to fetch the data you need.
How much data are we talking? (Rows?)

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/



"Jim Brandley" <jim.brandley@xxxxxxxxxxxx> wrote in message
news:1112642163.616688.210270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Are you saying that opening a datareader or filling a datatable do not
> create cursors on the database server? I do not see how those functions
> could be performed without a cursor.
>
> I am constructing the select statement dynamically based on the content
> of the request, and generating input parameters to match. Some of the
> tables I have to query have 100 - 200 columns, and I do not want to
> retrieve all for the (generally small) subset the users require. These
> forms do not change frequently, once or twice while the users configure
> the package to suit their needs, thereafter only as their business
> rules and requirements change. The prepared statements should remain in
> the db server cache most of the time, because I always generate the
> same select. The returned data lives on the web server only for a short
> time, and is likely different content (same columns but different
> different rows) for each session.
>


.

Relevant Pages

  • Re: Server LogIns without db roles
    ... is to use the cursor since there is no entry in the sys.database_principal ... | database on the server into a single view without using a cursor (some ... |>As to your other concern abou the single user mode, ... |>will not use the corresponding database if some one is using it. ...
    (microsoft.public.sqlserver.security)
  • Re: Delay
    ... adOpenDynamic and Server side cursor to get "fresh" data in the database. ... Please elaborate on the server-side cursor. ... without even the implied warranty of merchantability ...
    (microsoft.public.inetserver.asp.db)
  • Re: Server LogIns without db roles
    ... >This is Jiayi from Microsoft SQL Server team. ... >Just for your information, sp_MSforeachdb is implemented using the cursor, ... >As to your other concern abou the single user mode, ... >will not use the corresponding database if some one is using it. ...
    (microsoft.public.sqlserver.security)
  • Re: database persistence with mysql, sqlite
    ... records without reestablishing a database connection every time I ... left from the initial query. ... open cursor can lock-out writers, ... mod_python (Python Server Pages under Apache). ...
    (comp.lang.python)
  • Re: MS Best Practice - Load subset of a single Row
    ... I agree that dynamic SQL to get your data is the way i would go in this ... > I meant - stay away from writing your own cursor. ... >> create cursors on the database server? ... >> the db server cache most of the time, ...
    (microsoft.public.dotnet.framework.adonet)