… XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I’m… new – I’ve been using PHP for almost 10 years, so I want to try something else to refresh my mind. List of… problem with these languages they work as fast as PHP if believe to Shootout Benchmarks, so I’m not sure I should…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… use this method but this is told in PHP manual and so easy to catch. There are however more differences which may… course not. First you should consider if you need to do processing in PHP at all. Many summary tables can be built… much more efficient. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple job. The…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in… many cache items being invalidated at the same time? What alternative approach should be taken? Caching should be seen more as… optimizing what is necessary to meet your goals.” – a quote from Justin’s slides on instrumentation-for-php. In terms…
Comment: ORDER BY ... LIMIT Performance Optimization
September 4, 2006 By 93 Comments
… your rows you could try this for a faster alternative to RAND() (example in PHP): $var = row(“SELECT COUNT(id) FROM mytable”); $var…
Comment: Apache PHP MySQL and Runaway Scripts
May 24, 2008 By 20 Comments
… PHP-FastCGI, Which is exactly environment which I found it working ? When if we stick to apache what do you propose as alternative ? To… user friendly. Though I guess you can make front server to detect and error and display nicer message.
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts… course one can just enter commands from cli, execute some php/python/ruby script or anything else. Most importantly – this must… mmm_clone is configured to do mysql snapshots, this could be a better way to achieve the same: Alternative 6. Clone db1 from…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… of keep-alive connections. Lighttpd is often named as faster alternative. It is surely true if you server static content from… on newer Linux versions, which also can be used. Using PHP to serve files This usually comes in play if security control… is to use X-send-file or similar custom headers which make PHP script just to check restrictions and have web server to send…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… two baselines for comparison. First is speed of PHP Associative array. This is to show kind of peak speed possible at all… is APC alternative which supports caching user data both on disk and in shared memory. Appendinx: If you would like to repeat… all caches to work, ie query cache enabled, memcached running, apc enabled for cli mode etc. Main PHP File: global.php file with…
Comment: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
Hi, As an alternative, you can enable a log on-the fly, in any version from 4.1 to 6.0, using… an appropriate script. http://forge.mysql.com/snippets/view.php?id=81 To reroute the traffic without need of disconnecting the clients… use a IPTABLES command http://forge.mysql.com/snippets/view.php?id=82 Cheers Giuseppe
Comment: Alternatives of PHP ?
September 10, 2006 By 28 Comments
… line 
: simplexml_load_string(file_get_contents($filename)); http://www.php.net/simplexml_load_file Also as long as you use… use libxml (except if you use sablotron or other alternatives). If you like to limit your memory usage (in a constant manner… fits best), it does not matter if you develop with PHP (or any other language) since N years or 2 months…
