Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

用PHP写的一个过期会员清理工具 运行很慢

WBOY
Release： 2016-06-23 14:12:05
Original
1014 people have browsed it

主表是一张 会员表
其他为 会员记录表 约150个这种关联表

任务目标: 需要清除 一些过期的会员和会员记录

我的想法是 按会员 对表逐个删除记录 发现 奇慢
然后 把会员分每100个为一组 逐个表进行删除 效果略有提升 但还是非常慢
超过1000个会员同时被删除时 基本无法保证成功

不知道哪有高手 有遇到过类似情况 你们是用什么方法来解决的 指点一下 多谢了


回复讨论(解决方案)

慢也是sql问题
请给出你的db结构

你查看过期会员看看速度如何， 是不是由于你那个时间字段没有做索引？
还有就是你的表用的是什么数据引擎。
可以话， 直接加一个字段， 不需要删除， 直接将会员update为已删除？

Related labels：
用PHP写的一个过期会员清理工具 运行很慢
source：php.cn
Previous article：新手问个简单的问题 Next article：wamp无法启动了，然后发现apache也没有启动
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
2
1961
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
10
2122
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
1789
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
1689
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1697
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