每个用户都有新表吗? [英] New table for every user?

问题描述

我想为网站上的每个新用户创建一个新表，并且我假设会有很多用户，我确信搜索性能会很好，但是维护又有什么用呢?

I want to crate new table for each new user on the web site and I assume that there will be many users, I am sure that search performance will be good, but what is with maintenance??

这是MySQL，表数量没有限制.

It is MySQL which has no limit in number of tables.

非常感谢.

推荐答案

实际上，表也存储在表中.因此，在这种情况下，您将在用户表中进行搜索，而在系统表中进行搜索.

Actually tables are stored in a table too. So in this case you would move searching in a table of users to searching in the system tables for a table.

性能和可维护性将受到严重损害.

Performance AND maintainibility will suffer badly.

这篇关于每个用户都有新表吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！