BlameThePixel!

25.08.03 New post marker re-added [S]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 :D)

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 :D



Your Comments:

[]The Pope Said:
um, the new thing is messed up. it just says new all the time
[01.01.70 12:04 AM]


[]The Pope Said:
forum new thing*
[01.01.70 12:04 AM]


[S]CBWhiz Said:
no it doesnt, at least not for me.

Its the exact same query as before.

[01.01.70 12:04 AM]


[B]C1 Said:
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]


[]The Pope Said:
sounds like a bad case of Ambrosia. I mean Amnesia.
[01.01.70 12:04 AM]


[G]markavian Said:
What do you class as an index on a mySQL table? (trying to avoid a problem in future)
[01.01.70 12:04 AM]


[]SPAZ Said:
yes indeed that all true now penis
[01.01.70 12:04 AM]


[UA]tundraH Said:
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]


Donate to BlameThePixel:
Donate to BTP Via PayPal


[12 Queries, Page Loaded in 0.696722 Seconds]

ShoutMeUp

Xmas Greetings from waka waka waka waka []Unvalidated EmailChristmasRiddle 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]Bloopy toe []TheAbdBoy moose knuckle [S]Bloopy MeatLoaf []Spleet IdDoAnything4Lo ve []AlphaWolf rub n tug []TheAbdBoy tugboat []The Pope rope [S]Bloopy race []TheAbdBoy

-Latest-


Must be logged in to add new words

FictoLeague

You have to be logged in to vote...

Member Stats

Date: 28.03.24.
Members: 4731.
Latest: []Unvalidated Emailsdsakldsaldklasdsdsa
Active:
0 user(s)
1 guest(s)

On chat:
Lots of people

Files: 3330

Bloopy's Site
Get Firefox Get Opera Donate to BTP Via PayPal