From: <tr...@us...> - 2003-02-13 22:22:06
|
Update of /cvsroot/basedb/basedb In directory sc8-pr-cvs1:/tmp/cvs-serv501 Modified Files: README Log Message: updated LOCAL INFILE info (thanks, Philippe) Index: README =================================================================== RCS file: /cvsroot/basedb/basedb/README,v retrieving revision 1.23 retrieving revision 1.24 diff -C2 -d -r1.23 -r1.24 *** README 13 Feb 2003 12:26:44 -0000 1.23 --- README 13 Feb 2003 22:22:02 -0000 1.24 *************** *** 44,51 **** better performance. Be sure to enable the query cache, and maybe set query_cache_limit to a lower value than the default (10k should be enough). ! When you install MySQL, make sure that LOAD LOCAL DATA INFILE works. The ! binary distributions from mysql.com have this, but the packages included ! with some Linux distributions don't. If you compile MySQL yourself, you can ! configure with --enable-local-infile. As of BASE 1.2, PHP 4.3 is the ONLY supported version of PHP. Versions --- 44,58 ---- better performance. Be sure to enable the query cache, and maybe set query_cache_limit to a lower value than the default (10k should be enough). ! ! For better performance in some situations (result file upload, running ! plugins, etc.), BASE can use LOAD LOCAL DATA INFILE as an alternative to ! just doing plain INSERTS. If you want to use LOAD LOCAL DATA INFILE, you ! should configure MySQL with --enable-local-infile. The binary distributions ! from mysql.com have this, but the packages included with some Linux ! distributions don't. Also, PHP will need to be built against the MySQL ! libraries that come with MySQL, rather than against the ones that come with ! PHP. That is, PHP needs --with-mysql=... rather than just --with-mysql . ! Finally, for LOAD LOCAL to be used, there is an option in the configuration ! file for BASE (see further down in this README). As of BASE 1.2, PHP 4.3 is the ONLY supported version of PHP. Versions |