Newbie question: very slow performance

I am seeing very slow performance when using mysql++ to access a local
db.  By "very slow" I mean, slower by a factor of 100-1000, in
comparison to running the same queries (in every case, a call to a
stored procedure) by piping them into the mysql command line client.

Can anybody suggest what I my be doing wrong to get such bad
performance?  (It is likely someting simple, since I am new to mysql++.)

My code for one of the procedures is this:

     // throw away empty results that are side effect of multi-query
    void skip_remaining_multi_results(mysqlpp::Query &query)
    {
        while (query.more_results()) {
            query.store_next();
        }
    }
... 
    void get_some_data(const std::string &ck, std::string *result)
    {
        try {
            mysqlpp::Query query = con.query();
            query << "call get_some_data(" << mysqlpp::quote
                  << ck << ")";
            mysqlpp::Result res = query.store();
            if (res) {
                mysqlpp::Row row = res.at(0);  // count returns one row
                *result = row.at(0).get_string();
            }
            skip_remaining_multi_results(query);
        }
        catch (const mysqlpp::BadQuery& er) {
            // Handle any query errors
            throw sdb_exception(er.what(), QUERY);
        }
        catch (const mysqlpp::Exception& er) {
            // Catch-all for any other MySQL++ exceptions
            throw sdb_exception(er.what(), MYSQLPP);
        }
    }

Thanks for any suggestions!

Will


-- 
William F Dowling
william.dowling@xxxxxxxxxxx
www.scientific.thomson.com

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