Re: Questions about performance for huge table (100M+ rows)

[Rick James]

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.)