|
Posted by metlslime on 2002/12/23 18:26:17 |
This is the forum to ask questions about this website, report things that are broken, request features, etc.
Be sure to check out the FAQ as well. |
|
|
Bal
#986 posted by JPL on 2006/12/08 01:42:19
Shame on you :P
Big Database Change:
#987 posted by metlslime on 2006/12/12 03:00:30
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change:
#988 posted by metlslime on 2006/12/12 03:00:35
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change:
#989 posted by metlslime on 2006/12/12 03:00:39
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change:
#990 posted by metlslime on 2006/12/12 03:00:45
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change:
#991 posted by metlslime on 2006/12/12 03:00:55
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change:
#992 posted by metlslime on 2006/12/12 03:01:02
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Big Database Change
#993 posted by metlslime on 2006/12/12 03:21:37
so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)
Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.
Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.
(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)
Oh...
#994 posted by metlslime on 2006/12/12 03:22:15
And i might have gotten just rid of the RECURSIVE ERROR message. Maybe.
Umm..
#995 posted by metlslime on 2006/12/12 03:22:32
Er, Test?
#996 posted by metlslime on 2006/12/12 03:25:16
...
I Think I May Have Spotted An Error...
#997 posted by Kell on 2006/12/12 03:39:37
Testes...
#998 posted by metlslime on 2006/12/12 03:39:45
Okay, Another Freaking Test
#999 posted by metlslime on 2006/12/12 03:45:47
Yay 1000!
#1000 posted by neg!ke on 2006/12/12 03:50:42
err... test
Okay, Maybe It Works Now?
#1001 posted by metlslime on 2006/12/12 03:55:07
Is Posting Always Slow Now?
#1002 posted by metlslime on 2006/12/12 03:57:29
OKay, Since It's 4am
#1003 posted by metlslime on 2006/12/12 04:02:35
and things seem to be mostly working, i'm going to bed. Let me know how it goes :)
Lmbo
#1004 posted by Kinn on 2006/12/12 15:12:50
ZzZZZZzzz
#1005 posted by JPL on 2006/12/12 22:57:59
"fait dodo cola mon p'tit frere"
"fait dod t'auras du lolo"
French lullaby for metlslime ;)
Fight_Msgclub
#1006 posted by R.P.G. on 2006/12/13 18:26:37
RECURSIVE ERROR:
Error 1: There was a SQL error.
Error 2: There was a SQL error.
The first error of Func_Msgboard is, there was a SQL error.
The second error if Func_Msgboard is, there was a SQL error.
RPG:
#1007 posted by metlslime on 2006/12/13 21:33:04
I finally edited the "recursive error" message so that it would actually show BOTH errors. Too bad both errors are still completely vague. :P
(also, i almost typed your nickname as "RGB")
RGB?
#1008 posted by HeadThump on 2006/12/13 22:38:51
Wished you hadn't told me. I've been calling in to the office for years telling them, 'I don't know where he is. You know those replicants, they can be tricky. Could you wire another ten grand, I'm running low on peanut butter.'
Test
#1009 posted by metlslime on 2006/12/13 23:28:59
SQL Errors
#1010 posted by metlslime on 2006/12/14 00:02:09
all SQL errors should now give an error code and a filename and a line number, which means that if you get an error and tell me about it, i might actually be able to do something about it.
|
|
You must be logged in to post in this thread.
|
Website copyright © 2002-2024 John Fitzgibbons. All posts are copyright their respective authors.
|
|