Re: Walking Dataset, faster/better way?! Help!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
In regards to use of cursors, it depends what applications you develop.
If applications are desktop ones that are not used by many users, cusors are
definitely helpful for navigating a large set of records because
applications has no need to load all of records into a "in-memory" database.
Currently, ADO.NET is really poor in this aspect plus others. If you don't
want to use a cursor, simply close it after you get all of records.

Yuancai (Charlie) Ye
www.udaparts.com

"ChadCThomas" <ChadCThomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4AA0C2E8-55C2-405B-809B-CE12527A15BA@xxxxxxxxxxxxxxxx
> When we moved this functionality into SQL Server, it was the cursor that
> carried the weight for us.
>
> .Net will never perform this type of analysis the way SQL server can.
>
> "IUnknown" wrote:
>
>> Hi, Alex:
>> You need to use server cursor for your case. See if OleDBPro for
>> dotNet
>> is helpful to you at http://www.udaparts.com/oledbpronet.htm
>>
>>
>> "Alex" <Alex@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:33373BB1-E498-4B05-9B9E-BD0D9FE97286@xxxxxxxxxxxxxxxx
>> > Hi! I've been looking for the solution for this problem for a while
>> > now.
>> > I
>> > hope that someone out there knows a more efficient way to do this.
>> > In short, I have a Dataset with n amount of records. I need to go 1
>> > row
>> > at
>> > a time comparing values in some of its columns against similar columns
>> > in
>> > all
>> > other rows in the same Dataset. Then, I move to the next row and do the
>> > same
>> > again. When I find some qualified records I add those rows to another
>> > local
>> > Dataset that is being pushed back to SQL once the process is complete.
>> > But
>> > problem as you can see is that if there are thousands or rows in
>> > original
>> > dataset I end up processing n X n amount of rows and it seems to really
>> > hinder the performance and takes to long to process. If someone knows
>> > a
>> > better way to do such comparison please let me know. The source data
>> > comes
>> > from Oracle, but is stored in a regular Dataset so I'm opne to any
>> > suggestions.
>> >
>> > thanks in advance...
>> >
>> > Alex
>>
>>
>>


.

Relevant Pages

  • Visual Basic for Applications Help Problem
    ... Under Office 2003 Professional Edition with SP1, if I open the VBA ... Basic for Applications.) ... sits there with the mouse cursor changed to a hand. ... Assistance pane on the right of the window that gives me the chance to ...
    (microsoft.public.office.misc)
  • Re: Opinions on approach, please...
    ... applications that INTENTIONALLY used "locks" to ... records to serialize processing. ... non-issue with the types of applications that you would want to convert. ... The data for the cursor is fetched into an internal result set at the time ...
    (comp.lang.cobol)
  • Windows XP Cursor Problem
    ... I started having a problem with my cursor in numerous applications (e.g., ... Microsoft Internet Explorer, MS Word, Fireworks, Adobe Elements, etc.) The ... frozen on the eraser tool in these applications. ...
    (microsoft.public.windowsxp.general)
  • Re: Inter-program copying and pasting programatically?
    ... I've tried doing this with Asta sockets between 2 applications and it worked ... > copyright header to go at the top of a Delphi unit, ... > cursor is at in the other program? ... > I am mainly concerned with text / rich edit content at the moment. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Error adding command properties for stored procedure call
    ... I see you are using the SQL Native Client for SQL Server ... A server cursor is not allowed on a remote stored procedure or stored ... The stored procedure called is a test one that simply SELECTs the name field ... int InitializeAndConnect; ...
    (microsoft.public.data.oledb)