List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:October 27 2005 5:54am
Subject:Re: Retrieving 300K+ records
View as plain text  
Alex Vishnev wrote:
> 
> Before I jump
> into mysql C library, can anyone else confirm or deny that overhead of Row
> object (or others) can degrade the performance on large queries? 

Easily.  There are multiple copies of the data made, lots of memory 
being moved around, type conversions, etc.  This is not a low-overhead 
class.

There's an item on the Wishlist to alleviate some of this, and some 
ideas at how to implement it.  All that's wanted is someone interested 
enough to do it in a clean way that doesn't break the ABI.  Or, patience 
to wait until 3.x.
Thread
SSQLS contained within class definition compilation issueswilliam.lieberman25 Oct
  • Retrieving 300K+ recordsAlex Vishnev25 Oct
    • Re: Retrieving 300K+ recordsEarl Miles25 Oct
      • RE: Retrieving 300K+ recordsAlex Vishnev25 Oct
        • Re: Retrieving 300K+ recordsWarren Young27 Oct
      • RE: Retrieving 300K+ recordsAlex Vishnev26 Oct
        • Re: Retrieving 300K+ recordsWarren Young27 Oct
          • RE: Retrieving 300K+ recordsAlex Vishnev27 Oct
    • Re: Retrieving 300K+ recordsChris Frey26 Oct
      • Re: Retrieving 300K+ recordsEarl Miles26 Oct
        • Re: Retrieving 300K+ recordsChris Frey26 Oct
          • RE: Retrieving 300K+ recordsAlex Vishnev26 Oct
            • Re: Retrieving 300K+ recordsEarl Miles26 Oct
            • Re: Retrieving 300K+ recordsChris Frey26 Oct
  • Re: SSQLS contained within class definition compilation issuesahnkle28 Oct
    • New FeaturesFabricio Mota29 Oct
RE: SSQLS contained within class definition compilation issueswilliam.lieberman25 Oct
  • Re: SSQLS contained within class definition compilation issuesWarren Young27 Oct
Re: SSQLS contained within class definition compilation issuesWarren Young27 Oct