Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 对于分表的靠山查询

对于分表的靠山查询

WBOY
Release： 2016-06-13 11:07:03
Original
988 people have browsed it

对于分表的后台查询
我在做一个后台，管理帖子回复的，因为回复很多，后端对数据库进行了分表，

现在后台有个需求，需要产品能够根据时间对所有的回复进行审核，并分页，

这个不在同一张表里，我怎么按照时间分页啊，再者，数据库这10个表已经很大

每个表都是千万级别，用unionALL直接走不动，想问一下，有没有人做过这样的

后台，感激不尽
------解决方案--------------------
按指定时间范围从10个表中抽取数据到临时表

------解决方案--------------------
可以考虑分区，分表的话可以参考MERGE存储引擎

Related labels：
merge unionall
source：php.cn
Previous article： 现时的php是编译型还是解释型？ Next article：iframe框架里的弹出层 如何样能居显示屏的中间？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2067
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2230
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1874
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1757
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1789
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template