question on large tables (>=800 million records, 10 G bytes of data)# Database - 数据库
b*y
1 楼
Hello, this is a data set for data mining.
I believe the experiences on this case should be helpful in general.
The questions is, how to make fast queries on large tables
(>=800 million records, 10G bytes of data)
with ordinary machines ?
Below are some details:
There is only one table, with the following fields:
cabId CHAR(8), timestamps DATETIME, longitude FLOAT, latitude FLOAT, status
CHAR(1)
We want to be able to query on cabId, timestamps, latitude, and longitude.
We also need to find out a
I believe the experiences on this case should be helpful in general.
The questions is, how to make fast queries on large tables
(>=800 million records, 10G bytes of data)
with ordinary machines ?
Below are some details:
There is only one table, with the following fields:
cabId CHAR(8), timestamps DATETIME, longitude FLOAT, latitude FLOAT, status
CHAR(1)
We want to be able to query on cabId, timestamps, latitude, and longitude.
We also need to find out a