X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=doc%2Frrdgraph_libdbi.pod;h=2544a08cb73791fae720d67dfd7e282942b20fb5;hb=d9822df7ed5e8122cf3a62e4e99678e94007f504;hp=c84465d8f6ba736b1b65e2b275fc0f989255e19e;hpb=91b2f1022a195d008d818f283690ef63a00fd79c;p=pkg-rrdtool.git

diff --git a/doc/rrdgraph_libdbi.pod b/doc/rrdgraph_libdbi.pod
index c84465d..2544a08 100644
--- a/doc/rrdgraph_libdbi.pod
+++ b/doc/rrdgraph_libdbi.pod
@@ -138,6 +138,18 @@ To illustrate this here a command to create a graph that contains the actual val
 
 * To debug the SQL statements set the environment variable RRDDEBUGSQL and the actual SQL statements and the timing is printed to stderr.
 
+
+
+=head1 Performance issues with MySQL backend
+
+LibDBI has a big performance issue when you retrieve data from a MySQL server. Performance impact is exponentially based on the number of 
+values you retrieve from the database. 
+For example, it would take more than 2 seconds to graph 5DS on 150 hours of data with a precision of 5 minutes 
+(against 100ms when data comes from a RRD file). This bug has been fixed on latest version of LibDBI (not release yet). 
+At that time, you would need to compile libdbi and libdbi-drivers from CVS repository to fix it.
+You can find more informations on this libdbi-users mailing list thread : http://sourceforge.net/mailarchive/message.php?msg_id=30320894
+
+
 =head1 BUGS
 
 * at least on Linux please make sure that the libdbi driver is explicitly linked against libdbi.so.0