发信人: Assailant (反恐精英 勇救人质 拆弹专家), 信区: Database
标 题: Re: question on large tables (>=800 million records, 10 G bytes
发信站: BBS 未名空间站 (Thu Jan 18 20:33:23 2007)
how is the data collected, or updated/inserted? do you get a data feed at
certain time of the day, or is this going to be a static set of data you are
have you considered breaking the data into smaller groups of files, and load
only the needed data into a temp table when requested.
each of those files would contain all the data associated with that cabID.
and when a request comes in, read the file(s) and write them to a table for
you can do the same for timestamp, and location data. break them into small
data files overlap on information so the size of the total data grows 4
times, but it gives you the logical break down on what to load into DB for
query and reporting.
and upgrading your hardware will improve the preformance alot
※ 来源:·BBS 未名空间站 http://mitbbs.com·[FROM: 172.25.]