Re: Data throughput

anonymous_at_discussions.microsoft.com
Date: 05/01/04

  • Next message: anonymous_at_discussions.microsoft.com: "Some clarification to the original question" 
    Date: Sat, 1 May 2004 12:01:14 -0700

    The query is used to fill a CSV file that a third party
    application uses to generate charts driven by the
    ultimate Users. The reason I'm asking the question is to
    see if there are options to speed the flow of data from
    the Database to the CSV file to shorten the time it
    currently takes. I can't modify the 3rd parties software
    and I can't query less data so the ODBC seems like the
    place to look. Your answer is logical for different
    circumstances but doesn't get to the original question,
    ARE there items that can be tweaked in ODBC that can
    increase throughput?

    >-----Original Message-----
    >What can you do? Don't return 1 billion row resultsets,
    quite simple. No
    >human is able to digest that amount of information, so
    you should filter or
    >summarize it at the server using WHERE, SUM etc, and
    then return a more
    >limited number of rows to the client.
    >
    >--
    >Jacco Schalkwijk
    >SQL Server MVP
    >
    >
    >"Jim Abel" <jim.abel@lmco> wrote in message
    >news:5c7301c42d7f$a97fd480$a101280a@phx.gbl...
    >> I am trying to understand what things affect the
    >> throughput of data when queries are executed to SQL
    >> Server. I'm trying to determine if there are
    >> settings,pramiters or times that can improve the speed
    of
    >> a recordset being returned to the application.
    >> What I have noticed in our environment is that a
    >> recordset of 1,000 rows is returned very quickly where
    as
    >> a recordset of a 1,000,000,000 rows can take over an
    hour.
    >> I understand that the bandwidth will have a large
    effect
    >> on the time but there are times when the bandwidth is
    >> wide open and it still takes a significant amount of
    >> time. What things can I do/set to optimixe this as
    much
    >> as possible.
    >
    >
    >.
    >

  • Next message: anonymous_at_discussions.microsoft.com: "Some clarification to the original question"

    Relevant Pages

    • Recordset is Not Updateable
      ... The query is a 4 table join. ... Server all have defined PK. ... Now with a SQL Server 2000 backend, the recordset is not ...
      (microsoft.public.access.queries)
    • SQL Query to CSV or XLS file
      ... I'm completely ignorant of VB scripting, and ASP. ... It executes an SQL query and then displays the ... How do I then write the query data to the csv file that has the name the ... I have found lots of ways to write the file on the server, ...
      (microsoft.public.scripting.vbscript)
    • Re: Help with Microsoft help on linking Access to Outlook
      ... Tools - references - tick Microsoft Outlook object library. ... in the criteria cell in the graphical query builder. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
      (microsoft.public.access.formscoding)
    • Re: Help with Microsoft help on linking Access to Outlook
      ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
      (microsoft.public.access.formscoding)
    • Re: Help with Microsoft help on linking Access to Outlook
      ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
      (microsoft.public.access.formscoding)