Hello From Mexico

2 posts / 0 new
Last post
acoronadoiruegas
acoronadoiruegas's picture
Offline
Last seen: 2 years 5 months ago
Joined: Mar 2 2012
Junior Boarder

Posts: 3

Abel Alejandro Coronado Iruegas
Hello From Mexico

Hello everybody.

First of all congratulations for this amazing software.

According to the experience in implementations that are currently working which is the hardware requirement for 100 million records.

Thanks

Abel.

bdempsey
bdempsey's picture
Offline
Last seen: 2 months 1 day ago
Joined: Oct 27 2009
Platinum Boarder

Posts: 194

Robert Dempsey
Re: Hello From Mexico

Your mileage may vary, but you can expect the following performance:

[code]mysql> select count(*) from test1 where ai>=20000000;
+-----------+
| count(*) |
+-----------+
| 100000001 |
+-----------+
1 row in set (1.20 sec)

mysql> select min(col1),max(col1) from test1 where ai>=20000000;
+-----------+-----------+
| min(col1) | max(col1) |
+-----------+-----------+
| 1 | 1 |
+-----------+-----------+
1 row in set (3.22 sec)[/code]
on a machine with 16GB RAM and 2 4-core 2.00GHz Xeon processors.