Re: Retrieving 300K+ records

Chris Frey wrote:
> On Tue, Oct 25, 2005 at 03:14:52PM -0400, Alex Vishnev wrote:
>
> >        Query q << "select * from table";
> >
> >        mysqlpp::ResUse use = q.use();
> >        while ((row = use.fetch_row()))
> >        {
> >                string col1 = (string)row.lookup_by_name("col1");
> >                string col2 = (string)row.lookup_by_name("col2")
> >                float col3 = row.lookup_by_name("col3");
> >        }
>
>
> Before you jump completely to C, you might try using the .at() function
> to reference fields by index instead of by name.  This removes the repeated
> name lookup on each cycle of your loop.
>
> I haven't done timings, so I don't know if this is significant.
>
> - Chris

The name lookups aren't what cause the slowdown (for me, at least) -- it's 
translating from a mysql row to a MySQL++ Row object that takes all the time.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx