Yes, I believe so. On Fri, Nov 20, 2009 at 8:07 PM, <[email protected]> wrote: > Did you compile with optimizations enabled? > Sent from my Verizon Wireless BlackBerry > > -----Original Message----- > From: Pawel Aleksander Fedorynski <[email protected]> > Date: Fri, 20 Nov 2009 19:43:43 > To: General-purpose list for SOCI users.<[email protected]> > Subject: Re: [SOCI-users] SOCI mysql performance is inferior to PHP > > Hi Tianhao, > > Thanks so much for trying SOCI and for letting us know about this > problem. I'll look into it this sometime next week. Can you also > tell us something about the data you're fetching? I'm mostly asking > about the column types and the sizes of the values. > > Thank you, > > Aleksander > > On Fri, Nov 20, 2009 at 12:48 PM, Tianhao Qiu <[email protected]> wrote: >> Hi, >> >> I'm a new SOCI user. I like its interface and simplicity. But I'm >> rather surprised to see that SOCI's performance is much inferior in >> comparison to PHP when iterating a large table. I guess I could be >> doing something wrong since the difference is huge. The C++ code took >> one minute to iterate a table with more than 50,000 rows, while the >> equivalent PHP code took only one second. >> >> My environment: >> OS: RHEL5.2 x64 >> DB: mysqld 5.0.45 >> C++: gcc-4.3.1, statically linked to SOCI 3.0 >> PHP: 5.1.6 >> >> C++ code: >> >> rowset<row> rs = (m_db_session.prepare << "SELECT firmwareversion, >> objtype, category " >> "FROM FCPObject WHERE accepted_flag = 1"); >> for (rowset<row>::const_iterator it = rs.begin(); it != rs.end(); ++it) >> { } >> >> PHP code: >> >> $query = "SELECT firmwareversion, objtype, category ". >> "FROM FCPObject WHERE accepted_flag = 1"; >> $result = mysql_query($query, $link); >> while ($row = mysql_fetch_row($result)) >> { } >> >> Regards, >> >> Tianhao >> >> ------------------------------------------------------------------------------ >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >> trial. Simplify your report design, integration and deployment - and focus on >> what you do best, core application coding. Discover what's new with >> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>_______________________________________________ >> Soci-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/soci-users >> > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Soci-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/soci-users > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Soci-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/soci-users >
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
