On Friday 08 February 2008, Bogdan-Andrei Iancu wrote: > I'm really interested in focusing on things that really drawback openser > (as throughput) - and I do not refer at the non-sense lab tests (TM > performances :P) which more or less have 0 relevance in real life > scenarios. > > So, as a first plan, I wan to do some work on the DB part : I want to > add support for prepared statements which will give some speed up in > standard DB queries - 90% of the queries are standard and there is no > need to prepare, build query, pass it to the driver, to parse it (by > driver), etc.... I want first to add this support in usrloc module, only > for mysql backend.
Hi Bogdan, great that you plan to work on this problem. Prepared statements are also on my wish list.. :-) Do you plan also to change the DB API to only export a loading function (like in usrloc), as Daniel suggested? > If the result are promising, we can extend this to all modules using DB. > Then, we can investigate which other drivers support prepared statements > and to enhance them also - if not native supported, we can do it the > openser module. Right, i also see no real need to change all modules to use prepared statements. We should concentrate on performance critical parts like usrloc and perhaps auth_db like you said. Henning _______________________________________________ Devel mailing list Devel@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/devel