[Not Logged in] - 
| 25.08.03 | New post marker re-added |
![[S]](/images/iconstaff.png) CBWhiz
|
|
Heres how it went: I cnped the select query to phpmyadim, and took over 20 seconds to return (i stop it after 20 sec  )Obviously a 20 sec wait is unbearable. I did an EXPLAIN on it, and noticed that one of the tables, f_read, had NO INDEXES. After adding a few the searched rows thing decresed by like 5000. And, the query returned in under 2 sec. If you still experiance sluggish page loading tell me. UPDATE: From testing out other people's accounts (with permission) I have found that the new marker might stay up forever even without new posts. if this happens to you, hit mark all forums read, and that should fix the problem. I belive it was due to an invisible board creation, but im just clasping at straws
|
||
Donate to BlameThePixel:
[12 Queries, Page Loaded in 0.307758 Seconds]
ShoutMeUp
Xmas Greetings from waka waka waka waka
ChristmasRiddle
MERRY CHRISTMAS EVERYONE!
Spleet
Except for Spleet.
TheAbdBoy
Always bummin' a brother out.
Spleet
Happy New Year everyone! But Spleet.
TheAbdBoy
Word Association
All-10 Ago-
MiddleEastern
AlphaWolf
camel
![[S]](/images/iconstaff_long.png)
Bloopy
toe
TheAbdBoy
moose knuckle
Bloopy
MeatLoaf
Spleet
IdDoAnything4Lo ve
AlphaWolf
rub n tug
TheAbdBoy
tugboat
The Pope
rope
Bloopy
race
TheAbdBoy
-Latest-
Must be logged in to add new words
FictoLeague
You have to be logged in to vote...Member Stats
Date: 21.11.24.
Members: 4731.
Latest: sdsakldsaldklasdsdsa
Active:
0 user(s)
1 guest(s)
On chat:
Lots of people
Files: 3330
Your Comments:
um, the new thing is messed up. it just says new all the time
[01.01.70 12:04 AM]
forum new thing*
[01.01.70 12:04 AM]
no it doesnt, at least not for me.
Its the exact same query as before.
[01.01.70 12:04 AM]
where am i? What am i doing here. What is money. Who am i? Do i sound familiar? How does money work? Do u like my avatar? Wats a money? Can i rob a bank? Do i get money this way? Is pope gunna be a debugger? All this and more on...blah!
[01.01.70 12:04 AM]
sounds like a bad case of Ambrosia. I mean Amnesia.
[01.01.70 12:04 AM]
What do you class as an index on a mySQL table? (trying to avoid a problem in future)
[01.01.70 12:04 AM]
yes indeed that all true now penis
[01.01.70 12:04 AM]
Just so you know, the marker seems to be working properly now, without me having to mark all read manually.
[01.01.70 12:04 AM]