I've tried storing images in MYSQL DB, but I don't know if they get stored in cache like regular images. Seemed like they get downloaded every time I refresh the page, i.e. a big waste in bandwidth. Also, I have heard people say storing images in MYSQL will bog down the server.

I suspect wherever you put the banners, your pages will still load slower since the host we're on doesn't seem to like php/mysql.

Exactly true! Maybe if enough WebAir people suggest that they look into the SQL lag, maybe something will come of it. I know last night my pages were loading lightening fast and today they're slow again. :(

I don't understand? If the banners are pulled from my site instead of the MYsql database, It should be faster, no?

Yes, should be, less work for the Database.

ronnie

My banners come pretty quick, depends on your database I guess

Yes it should work faster but that's not the crux of the problem. The problem appears to be in the shared SQL connections. Put it this way, if your site takes 16seconds to load with the banners stored in the database or 15 seconds to load with the banners hosted on the domain, it doesn't really matter. It's the other 14 seconds we need to be concerned with. :)

I have a support ticket in about this, we'll see what they say.

Preacher

dedicated mysql databases in your dedicated host, plus they have to set the MySql to unlimited...Then you won't have any problems

I was just in touch with Webair yesterday. They said their SQL servers were "experiencing DNS problems". They moved me to an unaffected cluster and things improved greatly right away. Lets hope it lasts.

Cool, I'm going to try this right now :)

well, webair just said they restarted sql5, which supposedly will make it run faster. We'll see.

Have I mentioned before how much I love this board? |love|

Well no direct response to the trouble ticket but my site is running 10 times faster then it was earlier this morning. I'm hoping it holds. |thumb

edit: Oh and back to the point of the topic, I love phpadsnew!