Welcome to the MacNN Forums.

Chuckit · Jul 9, 2007, 06:37 PM

Did you use MS Paint for that?

CharlesS · Jul 9, 2007, 06:39 PM

It's supposed to make you laugh, not gape in awe at my nonexistent graphic abilities.

Rumor · Jul 9, 2007, 06:46 PM

Originally Posted by Dakarʒ

Is MacNN dying?

*sniff*

What? Does the hampstor smell dead?

MacosNerd · Jul 9, 2007, 06:54 PM

Originally Posted by Rumor

What? Does the hampstor smell dead?

You've never eaten at a school cafeteria?

mkbhatia · Jul 10, 2007, 01:11 AM

Originally Posted by exca1ibur

I get the same thing here.

http://forums.macnn.com/77/gaming/29...i-or-xb360/80/

Originally Posted by Dakarʒ

I'm usually loathe to do this, but curiosity killed the cat. I've been meandering around the forums this morning, and for some reason I keep getting a vBulletin Database error when i try and see one thread.

http://forums.macnn.com/95/political...our-grass-cut/

Usually I'd assume its a problem on my side, but it's the only thread that won't load. Is it possible it's borked somehow?

I tried some database maintenance stuff last night (you may have seen the forums down message), but it didn't completely fix the problems. Those URLs now load properly, but just take too much time. I have no idea why, since others load quite fast. I am looking into this.

besson3c · Jul 10, 2007, 02:03 AM

Originally Posted by mkbhatia

I tried some database maintenance stuff last night (you may have seen the forums down message), but it didn't completely fix the problems. Those URLs now load properly, but just take too much time. I have no idea why, since others load quite fast. I am looking into this.

Do you experience the same lag doing a select of the row from the MySQL client/command line interface? Just wondering, this is rather strange...

mkbhatia · Jul 10, 2007, 08:58 AM

Hard to tell if the command line makes a difference, because the file being called is very complicated. I did some database tweaks this morning, which seemed to have restored *some* of the speed in loading those URLs. Still working, though.

besson3c · 09:40 AM

Originally Posted by mkbhatia

Hard to tell if the command line makes a difference, because the file being called is very complicated. I did some database tweaks this morning, which seemed to have restored *some* of the speed in loading those URLs. Still working, though.

Do you mean that in order to select the data a MySQL subselect or view is necessary?

Let me know what you find! I'm no DBA, so I'd be interested in learning from your findings..

Dakarʒ · Jul 10, 2007, 09:38 AM

Originally Posted by mkbhatia

I tried some database maintenance stuff last night (you may have seen the forums down message), but it didn't completely fix the problems. Those URLs now load properly, but just take too much time. I have no idea why, since others load quite fast. I am looking into this.

Seems ok, right now, thanks.

seanc · 08:20 AM

Rofl, someone broke like 82 in /var/www/macnn/macnn/forums/includes/class_postbit.php(300) : eval()'d

Interesting changes going on today.

Can we keep the post count showing, now that it's back?

Dakarʒ · Jul 12, 2007, 11:48 AM

I'm posting this here, because I think it's related to the DB. Now instead of a thread not loading, it just seems to take forever. Once again, it only seems to apply to a particular thread.

http://forums.macnn.com/89/macnn-lou...-finally-free/

This isn't a big deal to me (at the moment) but I thought you guys might want a heads up, in case its the symptom of something.

seanc · 01:37 PM

A lot of threads are loading slowly, even Mkbhatia isn't sure why.

Dakarʒ · Jul 12, 2007, 01:14 PM

Perhaps she should contact Q Branch.

OreoCookie · Jul 12, 2007, 01:27 PM

Some threads won't load at all …

mkbhatia · Jul 16, 2007, 07:49 AM

While fixing the JS resizer, we ran into a problem that caused the thread to "hold" until it could get the size of all remote images, which caused some threads to be very slow ...we've now implemented a timeout function to prevent slow external servers from making this site sluggish.

There are other smaller issues that persisting and we are working to resolve those.

besson3c · Jul 16, 2007, 08:32 AM

Originally Posted by mkbhatia

While fixing the JS resizer, we ran into a problem that caused the thread to "hold" until it could get the size of all remote images, which caused some threads to be very slow ...we've now implemented a timeout function to prevent slow external servers from making this site sluggish.

There are other smaller issues that persisting and we are working to resolve those.

Was this caused by AJAX set to not work in asyncronous mode? If so, would creating more XML http request objects and event handlers help in this regard so that this data can be fetched asyncronously?