Re: ADO .NET right for raw data processing?

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 10:54:07 -0700

Stored procedures--no question. If the tests are complex, I might consider
calling an extended stored procedure. In the Yukon timeframe these can be
written in VB.NET or C# (and possibly other CLR languages).
Moving that volume of data to an application and back again is going to be
very expensive. Let the server crunch the data where it lives.
I would also consider reporting services to display the results... 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Tim" <tgaihdc@hotmail.com> wrote in message
news:d906e103.0407300745.42e7cdc0@posting.google.com...
> Is ADO .NET performance adequate for processing large volumes of data?
>  For example, say you have a 500,000 customers with 700,000 orders a
> month.  You want to identify trends over one year, so you need to scan
> over those 500,000 customers and 12 x 700,000 orders.  During the
> scan, you're checking each customer against 1000 different rules.  If
> you want to process 20 customers/sec, would ADO .NET be capable or
> should this all be done in a stored procedure(s)?
>
> Thanks in advance.
>
> Tim

Relevant Pages

  • ADO .NET right for raw data processing?
    ... Is ADO .NET performance adequate for processing large volumes of data? ... over those 500,000 customers and 12 x 700,000 orders. ... Tim ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Outlook contacts into Exchange GAL
    ... Tim, create a public golder for all of your companie's customers contacts. ... You can then set up Outlook, if you wish, to always check your public ... The GAL should really be used for a list of your SBS users. ...
    (microsoft.public.windows.server.sbs)
  • Re: Indexing a NAS share
    ... Indexing Services when one of your customers has a problem with Conveo? ... > "Tim" wrote in message ... >> to search) is to be stored on a NAS. ...
    (microsoft.public.inetserver.indexserver)
  • ADO Recordset open problem - only in Win98
    ... I have a problem that I need expert help. ... from DAO to ADO. ... So far we have not had a problem with Win2000 and WinXP customers who are ... exact same code that works fine in the other operating systems. ...
    (microsoft.public.vc.database)
  • Re: Further to BTs con trick on fees
    ... tim wrote: ... I would be happier if customers were encouraged to look at their bills and actively consider the service they were getting, rather than listen to dishonest justifications of DD. ...
    (uk.legal)