List:MySQL++« Previous MessageNext Message »
From:Alex Vishnev Date:October 27 2005 1:36pm
Subject:RE: Retrieving 300K+ records
View as plain text  
Warren Young wrote:

>You must be moving from flat files to a real database to get some 
>benefit.  You sound surprised that those benefits have a cost.

Warren, of course I understand that there should be some overhead/cost
associated with moving from flat file to mysql. In the first set of
benchmarks, when I was using mysqlpp::Row object it was 5 times longer.
Thanks to Earl, I was able to cut it down in 1/2. I guess I was looking to
see if anyone else had any more tips on how to make it faster by changing
code or manipulating MySQL tunable params. If not, well then I just have to
live with that ;-)

Alex


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