ADO GetString


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO GetString

  1. #1
    Mike Kenzie Guest

    ADO GetString


    I have noticed that if you are trying to format a large recordset in VB or
    VB script (say around 300 records), the GetString function can be substantially
    faster than looping through each record and formatting it that way. Are
    there any downsides to using the GetString function performance or scalability
    wise?

    Mike Kenzie
    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: ADO GetString


    I discuss this at some length in the new book (mentioned eariler). GetRows
    or GetString returns a variant array or a "pseudo" delimited string. Ok,
    now that you have the array or string, now what? You lose almost all (or
    all) of the DDL information but that might not be a problem--you still have
    the original Recordset. You do have the data, but to display it you have
    to figure out how to do this yourself. The Clip property can accept a delimited
    string, but the MSHFlexGrid.Recordset is faster and takes the ADO Recordset
    object directly. If you're considering passing the data from tier-to-tier,
    a DS is not a bad choice. It's ANSI (as opposed to Unicode), it's lightweight
    (no DDL), but it assumes the target knows what to do with it. There are lots
    of other tradeoffs discussed in the book...

    hth
    bv



    "Mike Kenzie" <mkenzie@solutechinc.com> wrote:
    >
    >I have noticed that if you are trying to format a large recordset in VB

    or
    >VB script (say around 300 records), the GetString function can be substantially
    >faster than looping through each record and formatting it that way. Are
    >there any downsides to using the GetString function performance or scalability
    >wise?
    >
    >Mike Kenzie


    Share on Google+

Similar Threads

  1. SQL2000 + ADO + Frame Relay question
    By Matt Brook in forum Database
    Replies: 0
    Last Post: 02-06-2002, 04:59 PM
  2. Compacting and Repairing MDB's in ADO
    By Filipo Novo Mór in forum VB Classic
    Replies: 3
    Last Post: 06-19-2001, 08:40 AM
  3. SV: Access DB and ADO
    By Tord Lindberg in forum VB Classic
    Replies: 0
    Last Post: 03-26-2001, 03:08 PM
  4. Whats new in ADO 2.6?
    By Jeff Pipes Jeff in forum VB Classic
    Replies: 2
    Last Post: 10-10-2000, 12:35 PM
  5. Stored Procedure - ADO - T-SQL Question
    By Neil Whitlow in forum Database
    Replies: 3
    Last Post: 08-20-2000, 11:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center