问题描述
我有一个包含数百万行的日志表。我正在考虑将数据分成多个表(即LoginHistory,ExceptionHistroy,PaymentProcessingHistory等)当使用具有许多行(不是列)和创建多个表的大表时,使用什么术语?
I have a Log table with millions of rows. I'm thinking about separating the data into multiple tables (i.e. LoginHistory, ExceptionHistroy, PaymentProcessingHistory, etc.) What is the term used when taking a large table with many rows (not Columns) and creating multiple tables?
我当前的日志表模式类似于:LogID,LogMessage,LogReason,LoggedBy,LoggedOn等。
My current Log table schema resembles: LogID, LogMessage, LogReason, LoggedBy, LoggedOn, etc.
太多东西在一张桌子,我想?
The problem is I'm putting too many things in one table, I think? Perhaps the table is too generic?
感谢
推荐答案
是术语de jour。从链接:
Sharding is the term de jour. From the link:
这篇关于具有百万行的日志表。怎么办?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!