CRecordset too slow

This is a discussion on CRecordset too slow within the Windows Programming forums, part of the Platform Specific Boards category; I am using a MFC CRecordset (ODBC consumer) and opening as a forward only. A standard select returns 50K to ...

  1. #1
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,855

    CRecordset too slow

    I am using a MFC CRecordset (ODBC consumer) and opening as a forward only. A standard select returns 50K to 100K of records for a 24 hour period.

    On a local DB (low ping) this is fine, select + processing times under 2 seconds.

    On a network DB (high ping) this blows out to 60-90 seconds (and this will be used from a remote site.....).

    It appears the CRecordset still needs to communicate with the DB each time I move thru the records (slowing it down). Even using a SAO (snapshot) does not improve performance.



    Any ideas to improve the speed?

    Would moving to WIN32 help (anyone actually tried this)?



    Code:
    rsMain.Open(CRecordset::forwardOnly ,sSQL , CRecordset::readOnly | CRecordset::noDirtyFieldCheck);
    If I can get these queries down to an acceptable time I can colour this one done......
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

  2. #2
    Yes, my avatar is stolen anonytmouse's Avatar
    Join Date
    Dec 2002
    Posts
    2,544
    A couple of ideas.

    1. The web seems to think that OLEDB may be faster than ODBC. CRecordset only supports ODBC. If your database supports OLEDB, you could test the difference between ODBC and OLEDB connection strings with a script to see whether it is worth changing.

    2. MSDN has something about Fetching Records in Bulk.

  3. #3
    Woof, woof! zacs7's Avatar
    Join Date
    Mar 2007
    Location
    Australia
    Posts
    3,459
    Of course Win32 should be faster, as You -> MFC -> Win32 -> Subsystem

    Rather, You -> Win32 -> Subsystem

    I tend to steer clear of MFC, mainly cause its bloated and a tad-weird

  4. #4
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,855
    Thanks....

    I was trying to avoid the bulk version of CRecordset......

    I am adding to a legacy app in C WIN32 with MFC dlls. DB is SQL Server 2005.

    Looks like my connection is throttled to the DB server (thru the client's network) and this is slowing down my app on each call to advance the CRecordset. Running without this throttling the app performs well within the requirements (1-2 sec to assemble and graph the 50K of records).

    zacs7
    I suppose the question was, by how much is WIN32 faster?

    I suggest you take another look at MFC, I find many people are biased against MFC for no good reason.

    Whats a few Kb on the size of the app when MFC saves me months of dev time?
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

  5. #5
    Woof, woof! zacs7's Avatar
    Join Date
    Mar 2007
    Location
    Australia
    Posts
    3,459
    I'm against MFC cause there is nothing wrong with getting down and dirty with Win32, there's really no middleman needed

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Program is slow. Help
    By jjj93421 in forum C++ Programming
    Replies: 14
    Last Post: 08-08-2004, 07:39 AM
  2. slow typing ad highlighting
    By axon in forum Tech Board
    Replies: 10
    Last Post: 01-13-2004, 07:27 PM
  3. MFC insert into access db (CRecordset)
    By maes in forum Windows Programming
    Replies: 11
    Last Post: 12-23-2003, 07:49 PM
  4. slow game
    By lambs4 in forum Game Programming
    Replies: 2
    Last Post: 08-21-2003, 02:08 PM
  5. Solutions for slow performance?
    By Hunter2 in forum Game Programming
    Replies: 52
    Last Post: 08-24-2002, 10:04 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21