0
votes
1answer
121 views

How to calculate amount of memory being used for processing an array

I have an array of 6 million database records. Each record has 100 columns. Is there a formula to calculate the amount of memory that is being utilized by the server? Will this be exponential? The ...
26
votes
7answers
6k views

Mysql: Working With 192 Trillion Records… (Yes, 192 Trillion)

Here's the question... Considering 192 trillion records, what should my considerations be? My main concern is speed. Here's the table... CREATE TABLE `ref` ( `id` INTEGER(13) AUTO_INCREMENT ...