What software do you use for banner managment on your sites?

[ronnie]

Originally Posted by ponyman

I'm using the javascript invocation code, as my pages are straight .html and not .php. This seems to be causing my pages to load much more slowly

Does anyone know a fix for this?
[/url]

Just run php on your html pages by adding this line to your htaccess file:

AddType application/x-httpd-php .html

Been using it for a long time. Put any php on your html pages and it runs fine.

ronnie

[ponyman]

No way! It's not that easy is it? There must be some catch to this technique

[ronnie]

Originally Posted by ponyman

No way! It's not that easy is it? There must be some catch to this technique

The catch is putting that line in your htaccess file, thats it. My main site, most all pages are html but I run a lot of php on them. So not only for phpadsnew, but for any php you want to run.

There have been people that say it can cause a slight load on the server, as it parses every html page for php before outputting, but I have not seen a problem myself. Nor have I heard any one else that has had a problem.

ronnie

[ponyman]

hmmm it's not working.

I put this in my .htaccess in the root and the folder, but it doesn't work. I see no phpadsnew calls on the page at all.

[mudsnake]

I put this in my .htaccess file
AddType application/x-httpd-php .html
on a test page and had no problem. How did you upload the banners? local banner(Sql) is were I put mine unless its a text ad.
EDIT:
ronnie thankyou for the info great |rock|

[ponyman]

hmm I still can't get this to work.

I put that snippet in my .htaccess file and then use the local invocation codes... but nothing appears

Phpadsnew admin runs kinda slow it seems, too.

[Preacher]

Originally Posted by ponyman

Phpadsnew admin runs kinda slow it seems, too.

Same here, but if I recall didn't you recently move to WebAir? I'm hosted there as well and all my SQL based calls are slow. It's an issue I'm going to be bringing up to them shortly.

[Lemmy]

I'm also with Webair. Anything HTML is pretty fast, big movies load zippy, but if there's a database involved it's like watching paint dry (slowly).

[Preacher]

Whew. Glad to know it's not just me.

[ponyman]

Originally Posted by Preacher

Same here, but if I recall didn't you recently move to WebAir? I'm hosted there as well and all my SQL based calls are slow. It's an issue I'm going to be bringing up to them shortly.

I've been with webair for a few years now, yes. Ponygirl is the webmaster who just moved to webair.

[Halfdeck]

Same here...HTML pages load at lightening speeds but pages with PHP can take 30 seconds to load. I tried to sort this out but seems they can't find the solution.

Also, I have some files in /stats/ directory that are already indexed by google/yahoo, and webair has a quirky setup where any call to /stats/ directory on a domain redirects to the webair login page, which makes moving one of my main domains over to webair pretty much impossible.

Originally Posted by Lemmy

I'm also with Webair. Anything HTML is pretty fast, big movies load zippy, but if there's a database involved it's like watching paint dry (slowly).

[Lemmy]

Originally Posted by Halfdeck

I tried to sort this out but seems they can't find the solution.

Could over congestion on the SQL servers be the problem? Cheap price comes at a cost. I'm counting my pennies to see when I can afford a dedicated server.

[ronnie]

Originally Posted by ponyman

hmmm it's not working.

I put this in my .htaccess in the root and the folder, but it doesn't work. I see no phpadsnew calls on the page at all.

You could always put some php code on your html pages to make sure the htaccess line is working like,

PHP Code:

<? echo "This is php working on a html page"; ?>

If that works, you've eliminated the htaccess code.

ronnie

[ponyman]

Maybe this will work faster if I store the banners in a folder in the domain instead of in mysql?

[ronnie]

I've always stored/pulled banners from my sites, never stored them in MYSQL. Not sure if there is a real benifit to storing them in the DB. My thought, the more you store in the db, the more info it has to go through to run. The bigger the DB, the more chance it will be slower.

ronnie

[Halfdeck]

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.

[Preacher]

Originally Posted by Halfdeck

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.

[ponyman]

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

[ronnie]

Originally Posted by ponyman

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

[Vendzilla]

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

[Preacher]

Originally Posted by ponyman

Maybe this will work faster if I store the banners in a folder in the domain instead of in mysql?

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

[Vendzilla]

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

[Lemmy]

Originally Posted by Preacher

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

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.

[ponyman]

Originally Posted by Lemmy

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

[ponyman]

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