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

ronnie · 2005-08-22, 06:23 PM

Quote:

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 · 2005-08-22, 06:39 PM

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

ronnie · 2005-08-22, 07:31 PM

Quote:

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 · 2005-08-23, 12:25 AM

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.

ronnie · 2005-08-24, 10:53 PM

Quote:

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

mudsnake · 2005-08-23, 01:53 AM

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 · 2005-08-24, 02:29 AM

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 · 2005-08-24, 12:33 PM

Quote:

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 · 2005-08-24, 02:54 PM

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 · 2005-08-24, 03:46 PM

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

Halfdeck · 2005-08-24, 09:21 PM

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.

Quote:

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 · 2005-08-24, 10:19 PM

Quote:

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.

ponyman · 2005-08-24, 06:02 PM

Quote:

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.

ponyman · 2005-08-25, 06:06 AM

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

Preacher · 2005-08-26, 01:21 PM

Quote:

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

Lemmy · 2005-08-26, 01:54 PM

Quote:

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 · 2005-08-26, 04:56 PM

Quote:

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

ronnie · 2005-08-25, 08:02 AM

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 · 2005-08-25, 08:23 AM

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 · 2005-08-25, 11:01 AM

Quote:

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 · 2005-08-26, 04:31 AM

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

ronnie · 2005-08-26, 08:02 AM

Quote:

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 · 2005-08-26, 11:01 AM

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

Vendzilla · 2005-08-26, 01:27 PM

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

ponyman · 2005-08-26, 06:52 PM

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

2005-08-22, 06:39 PM	#2
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	No way! It's not that easy is it? There must be some catch to this technique __________________ Dirty Old Men Sponsors - gay & straight

2005-08-23, 12:25 AM	#4
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	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. __________________ Dirty Old Men Sponsors - gay & straight

2005-08-23, 01:53 AM	#6
mudsnake WHO IS FONZY!?! Don't they teach you anything at school? Join Date: Jun 2005 Posts: 44	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\| __________________ Muds Erotic Sluts

2005-08-24, 02:29 AM	#7
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	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. __________________ Dirty Old Men Sponsors - gay & straight

2005-08-24, 02:54 PM	#9
Lemmy You can now put whatever you want in this space :) Join Date: Sep 2004 Location: Next door to a kid with a moped. Posts: 1,492	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). __________________ BUY MY PORNSITES!

2005-08-24, 03:46 PM	#10
Preacher There's Xanax in my thurible! Join Date: Apr 2005 Location: Wherever they screw on my head Posts: 2,441	Whew. Glad to know it's not just me. __________________ NSCash * This Depraved World

2005-08-25, 06:06 AM	#14
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	Maybe this will work faster if I store the banners in a folder in the domain instead of in mysql? __________________ Dirty Old Men Sponsors - gay & straight

2005-08-25, 08:02 AM	#18
ronnie Wheither you think you can or you think you can't, Your right. Join Date: Jun 2004 Location: midwest Posts: 2,274	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

2005-08-25, 08:23 AM	#19
Halfdeck You can now put whatever you want in this space :) Join Date: Oct 2004 Location: New Haven, CT Posts: 985	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. __________________ Success is going from failure to failure without a loss of enthusiasm.

2005-08-26, 04:31 AM	#21
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	I don't understand? If the banners are pulled from my site instead of the MYsql database, It should be faster, no? __________________ Dirty Old Men Sponsors - gay & straight

2005-08-26, 11:01 AM	#23
Vendzilla And Lord, we are especially thankful for nuclear power, the cleanest, safest energy source there is. Except for solar, which is just a pipe dream Join Date: Feb 2004 Location: The Mansion Posts: 226	My banners come pretty quick, depends on your database I guess

2005-08-26, 01:27 PM	#24
Vendzilla And Lord, we are especially thankful for nuclear power, the cleanest, safest energy source there is. Except for solar, which is just a pipe dream Join Date: Feb 2004 Location: The Mansion Posts: 226	dedicated mysql databases in your dedicated host, plus they have to set the MySql to unlimited...Then you won't have any problems

2005-08-26, 06:52 PM	#25
ponyman Nobody gets into heaven without a glowstick Join Date: Jun 2004 Location: The Great Northwest Posts: 422	well, webair just said they restarted sql5, which supposedly will make it run faster. We'll see. __________________ Dirty Old Men Sponsors - gay & straight