Results 1 to 3 of 3

Thread: Why is ADO much slower than The intrinsic Datacontrol that comes with VB

  1. Dec 9th, 2003, 05:03 AM #1
    Moonbot
    Moonbot is offline

    Thread Starter
    New Member
    Join Date
    Dec 2003
    Posts
    1

    Why is ADO much slower than The intrinsic Datacontrol that comes with VB

    I have a Flat Table with 50000 + (Part Codes) and am using Component Ones' TruegridPro to display them

    Whilst using the Intrinsic Data Control that ships with VB - this grid loads these records almost instant

    However when I use the ADO Data control - it takes about 20 seconds to load

    Has Microsoft gone backwards in their approach or is it just me?(I'm sure it's me!)

    Can anybody offer suggestions
    Reply With Quote Reply With Quote
  2. Dec 9th, 2003, 05:47 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    C1's probably implemented a real fast method to perform the loading of the data. I think it really depends upon the cursor location, cursor type, lock type, connection type, etc. that you use.
    Reply With Quote Reply With Quote
  3. Dec 9th, 2003, 08:37 AM #3
    sw_is_great
    sw_is_great is offline
    Hyperactive Member sw_is_great's Avatar
    Join Date
    Nov 2003
    Posts
    330
    it also depends on the table from which u r selecting...
    whether u have proper index created on it or not ....
    Regards
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width