|
2003-09-05, 12:03
|
#34 |
Aug 2002
2×32×13×37 Posts |
I'm just posting this here so I can find it again... Run along... Nothing to see here... :)
[code:1]mysql> ALTER TABLE phpbb_search_wordmatch DROP INDEX post_id; Query OK, 294765 rows affected (34.13 sec) Records: 294765 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE phpbb_search_wordmatch ADD INDEX post_id (post_id); Query OK, 294765 rows affected (1 min 36.67 sec) Records: 294765 Duplicates: 0 Warnings: 0[/code:1] http://www.phpbb.com/phpBB/viewtopic.php?t=49879 http://www.phpbb.com/phpBB/viewtopic.php?t=33141 |
|
|
|
2003-09-05, 19:24
|
#35 |
|
Aug 2002
2×32×13×37 Posts |
I've disabled editing posts for regular members to see if this helps... You can still preview your post before you submit it...
Moderators have full edit permissions but I'd ask that you limit your edits to ones that require moderator intervention and not your ordinary posts... I know this has been a real inconvenience to you all and I apologize for it... :( |
|
|
|
|
2003-09-05, 19:34
|
#36 |
Dec 2002
Frederick County, MD
5628 Posts |
Not that I know anything about how to fix the problem, but would it make a difference if you could still edit a post if your post was still the last post? I've noticed that edits to posts like this didn't add to the total edit count.
|
|
|
|
|
2003-09-05, 20:31
|
#37 | |
Aug 2003
Upstate NY, USA
2·163 Posts |
Quote:
|
|
|
|
|
|
2003-09-05, 21:25
|
#38 |
Jan 2003
North Carolina
2·3·41 Posts |
I have no idea if this applies, but I run a critical (to us) database where I work. It grows 15-20% per year. It needs to get exported and imported a few times a year to reorganize the data cleanly. Usually pick up 20-25% speed improvement when we do it.
A thought . . . |
|
|
|
|
2003-09-05, 22:57
|
#39 |
|
Aug 2003
Upstate NY, USA
2×163 Posts |
would it be speedier if we were allowed to delete our own posts, so as to not take as much space on the server?
|
|
|
|
|
2003-09-05, 23:15
|
#40 |
Aug 2002
2×32×13×37 Posts |
The space is not an issue... Reading the forum is not an issue... We've had 66 people on at one time before...
The problem is that to edit a post the software deletes it and then reinserts it... Apparently this is a big problem... (Those links explain it in great detail!) For now let's try it without edits for a few days and see what happens... |
|
|
|
|
2003-09-08, 14:15
|
#41 |
May 2003
23×3 Posts |
[code:1]
phpBB Created this page in 23.255707 seconds : 16 queries executed phpBB Created this page in 14.298839 seconds : 16 queries executed phpBB Created this page in 15.966841 seconds : 13 queries executed [/code:1] That was around 5 minutes ago. Now it is fast again. Greetings, Matthes |
|
|
|
|
2003-10-07, 13:05
|
#42 |
|
Dec 2002
Frederick County, MD
2×5×37 Posts |
So,
any speed problems since the software change? |
|
|
|
|
2003-10-08, 01:27
|
#43 |
Sep 2002
Austin, TX
3×11×17 Posts |
It is Dial-up and ISDN friendly
 .
|
|
|
|
 |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ECM RAM issues | yoyo | GMP-ECM | 7 | 2018-04-28 05:51 |
| Windows 10 Issues | Sulamandora | Software | 5 | 2015-08-13 06:47 |
| Mersenne.org Issues | SiliconSentry | Information & Answers | 3 | 2014-05-21 22:36 |
| New GPU; new issues... | chalsall | GPU Computing | 18 | 2013-06-12 19:28 |
| memory issues? | jcjuice | Hardware | 7 | 2006-01-11 20:41 |
