MySQL Forums
Forum List  »  Performance

Re: Questions about performance for huge table (100M+ rows)
Posted by: Rick James
Date: January 21, 2009 11:04PM

Victor... I always use Perl or PHP. They give me a lot of power. Sure, they are interpretive languages (hence, slower than C), but CPU time in the application is rarely the bottleneck. With huge tables, it is disk I/O. C++ is too verbose; that hampers my productivity. Abstraction products, no thanks. I need to type the SQL myself (or, sometimes, construct it via Perl/PHP). I do use layers in Perl/PHP to simplify coding, such as
$foo = $db->Hashes("SELECT ...");
returns an array of hashes (associative arrays). (As opposed to the several statements required by the low level primatives.)

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.