chrometweaks.org

Please Help Me!!! I Need To Find A PHP and MYSQL DATABASE FREE iPage hosting service!?

Click Here To View All Answers...


My 1st question is: Please Help Me!!! I Need To Find A PHP and MYSQL DATABASE FREE iPage hosting service!? Thanks in advance for any answer. Another question I got... Hello. I am having trouble with the page loading speed using osc. My current html based iPage site will load a pg with 10 thumbnails and several gifs in about 1 minute at 56k. My new osc based iPage site will load the catalog pg with only 7 thumbs and 2 gifs in 3 MINUTES 45 SECONDS at 56k!!!! This obviously is unacceptable.

I have over 1k of images total, with one category having 250 thumbs.

Speed is my remaining issue before switching to the new site. Any help would be appreciated..

Thanks.

D5..

Comments (307)

Hmm... I need to find out myself. I don't know what is the answer. I'll do some research in Google and get back to you if I got an useful answer. You should email the people at iPage as they probably can help you..

Comment #1

Not sure I can respond to this without more info. Any chance you can send a pointer to the current and the new store?.

OsC shouldn't cause any dramatic slowdown, unless you are having a server or database problem..

What is your page parse time? This is the time it takes osc to render your page, the rest is pure serving, connection speed, and your browser rendering. If you have errors on your page, it will take MUCH longer for your browser to render it..

Dan..

Comment #2

Dan, thanks for responding. My iPage site is an 'adult site' and I would not want to offend. I have a friend using osc in basically the same way. Her page loads with 20 thumbs in about 50 seconds.(at 56k) 4 times faster! She is away on vacation so I can't ask how..

How do I get page parse times?.

No errors are evident?.

I removed the 'thumbnail generator' with no resulting change, so I assume it was not working..

Thanks.

D5.

This post has been edited by.

Dragon5.

: 03 July 2004, 18:08..

Comment #3

You can turn page parse times on in admin. Without a link to the sites it is almost impossible to give any more help. When/if you post them, just put a note that they are adult sites so that people know and can make a decision on whether to help or not based on that...

Comment #4

Alright. Here are the links:.

WARNING This is an adult site. (GAY) If you have a problem with that, please don't go there..

Original html iPage site here: www.bakdoor.com (remember, this is my first attempt! go easy).

New osc site: www.bakdoor.com/catalog. SLOOOOOWWWW as molasses..

Will look in admin for the parse time stuff..

Thanks.

D5..

Comment #5

Ok, I give up. How do I get the page parse times?.

Thanks..

Comment #6

Your cautions about the iPage site are well founded. However....

Clicked on one thumbnail to check the size, and came up with 102K. If you have large graphics, and are resizing them to display on your new items and product listings, this will go a long way to account as to why you have slow load times. I have dsl, so is not really a problem..

You might want to check out some of the image contributions for either using multiple images or size contributions to cut way down on the size of your thumbnail displays..

This post has been edited by.

Geotex.

: 03 July 2004, 23:11..

Comment #7

Thanks. Yes I am aware of the image size considerations. I have tried 3 different contributions and none have yet to work! No errors, just don't do what they claim. See my post just below this one. ('PHP Question') I have cable here and dial-up at another location, so I can check differences..

Thanks..

Comment #8

Do you have GD compiled into PHP on your server? This is required for the image resizing mods.

Matti.

This post has been edited by.

Johnson.

: 03 July 2004, 23:19..

Comment #9

Web Page Speed Report.

URL:.

Http://www.bakdoor.com/catalog/.

Title: BakDoorVideos.

Date: Report run on Sat Jul 3 18:25:18CDT2004.

Diagnosis.

Global Statistics.

Total HTTP Requests: 14.

Total Size: 415118 bytes.

Object Size Totals.

Object type Size (bytes).

HTML: 3599.

Images: 405632.

Java script: 0.

CSS: 5887.

Multimedia: 0.

Other: 0.

External Objects.

External Object QTY.

Total Images: 12.

Total CSS imports: 1.

Download Times*.

Connection Rate Download Time.

14.4K 321.94 seconds.

28.8K 161.07 seconds.

33.6K 138.09 seconds.

56K 82.93 seconds.

ISDN 128K 25.54 seconds.

T1 1.44Mbps 2.40 seconds.

*Note that these download times are based on the full connection rate for ISDN and T1 connections. Modem connections (56Kbps or less) are corrected by a packet loss factor of 0.7. All download times include delays due to round-trip latency with an average of 0.2 seconds per object. With 14 total objects for this page, that computes to a total lag time due to latency of 2.8 seconds. Note also that this download time calculation does not take into account delays due to XHTML parsing and rendering..

Page Objects.

QTY SIZE# TYPE URL.

1 102844 IMG.

Http://www.bakdoor.c...gblackstuds.jpg.

1 95611 IMG.

Http://www.bakdoor.c...ges/bangers.jpg.

1 91835 IMG.

Http://www.bakdoor.c...utifulblack.jpg.

1 90448 IMG.

Http://www.bakdoor.c...tinboygirls.jpg.

1 11698 IMG.

Http://www.bakdoor.c.../oscommerce.gif.

1 8957 IMG.

1 5887 CSS.

Http://www.bakdoor.c.../stylesheet.css.

1 3599 HTML.

Http://www.bakdoor.com/catalog/.

1 2548 IMG.

Http://www.bakdoor.com/catalog/images/cred...ards-square.gif.

1 605 IMG.

Http://www.bakdoor.c...er_checkout.gif.

1 535 IMG.

Http://www.bakdoor.c...header_cart.gif.

1 439 IMG.

Http://www.bakdoor.c...der_account.gif.

3 69 IMG.

Http://www.bakdoor.com/catalog/images/info...arrow_right.gif.

41 43 IMG.

Http://www.bakdoor.c...pixel_trans.gif.

14 ^ 415118* Total (^unique objects).

# This iPage site is using HTTP compression, otherwise called content encoding using gzip. The sizes reported here are for compressed content sent from the server to the client..

* CSS alternate stylesheets may be referenced in the HTML but are not actually downloaded until they are needed and are therefore not included in the total page size..

Analysis and Recommendations.

TOTAL_OBJECTS - The total number of objects on this page is 14 - consider reducing this to a more reasonable number. Combine, refine, and optimize your external objects. Replace graphic rollovers with CSS rollovers to speed display and minimize HTTP requests..

TOTAL_IMAGES - The total number of images on this page is 12 , consider reducing this to a more reasonable number. Combine, refine, and optimize your graphics. Replace graphic rollovers with CSS rollovers to speed display and minimize HTTP requests..

TOTAL_CSS - The total number of external CSS files on this page is 1Because external CSS files must be in the HEAD of your HTML document, they must load first before any BODY content displays. Although they are cached, CSS files slow down the initial display of your page..

TOTAL_SIZE - The total size of this page is 415118 bytes, which will load in 82.93 seconds on a 56Kbps modem. Consider reducing total page size to less than 30K to achieve sub eight second response times on 56K connections. Pages over 100K exceed most attention thresholds at 56Kbps, even with feedback..

HTML_SIZE - The total size of this HTML file is 3599 bytes, which less than 20K. Assuming that you specify the HEIGHT and WIDTH of your images, this size allows your page to display content in well under 8 seconds, the average time users are willing to wait for a page to display without feedback..

IMAGES_SIZE - The total size of your images is 405632 bytes, which is over 30K. Consider optimizing your images for size, combining them, and replacing graphic rollovers with CSS..

CSS_SIZE - The total size of your external CSS is 5887 bytes, which is above 1160 bytes and less than 8K. For external files, try to keep them less than 1160 bytes to fit within one higher-speed TCP-IP packet (or an approximate multiple thereof). Consider optimizing your CSS and eliminating features to reduce this to a more reasonable size..

This post has been edited by.

Johnson.

: 04 July 2004, 11:40..

Comment #10

Whew! Where to start? I have 500 more items to add to site! Not until I fix the speed issue! 'Consider contacting us'? Who are you and what do you do?.

Thanks.

D5..

Comment #11

Sorry, that part was not supposed to be in there, however my recommendation is to make the images smaller with some image editor (personally I use photoshop) and then for enlarging, I have another image which is larger in size. this way, if someone wants to see a larger image they have the option. the way you are doing it, the image, whether it be thumbnailed or large, they are the same physical byte size..

Comment #12

Yes, I understand that. I do use photoshop and I'm reducing the byte size.I also have thumbs of all jpegs. Like I mentioned before, I have tried a number of image contribs to no avail. How are you accessing the thumbs and then the large image seperately? I realize that osc's constant sizing/resizing is way slow..

Tom..

Comment #13

Hi Thomas,.

Although I don't support any sort of "adult" site, you may want to look at this thread:.

Http://forums.oscomm...showtopic=96780.

Especially the code that Gareth posted on the second page..

Peter..

Comment #14

Thank you all. Big Image contribution is installed and working. Finally! All images have been resized. Thank you photoshop! Thumbnails have been created. Thank you EasyThumb!.

Big image requires 2 images. One for the thumb and 1 for the enlarge. Any easy way to update 1000 images/paths in osc or do I have to do each one manually!.

Reminds me of another question. Where is the path for each image stored?.

Thanks.

D5..

Comment #15

Hi,.

You can use the SQL side of phpMyAdmin to update one, then see what SQL code is required to update it. Copy that code to an editor and populate for the 1000 images. Sounds a bit messy, you still have to match the image name to the product ID..

Take a look at "Easy Populate", but I think that is only for populating (new) products, not too sure ??.

By default /catalog/images , but of course can be anywhere you specify in configure.php.

Peter..

Comment #16

Thank you. I understand that images are stored in catalog/image. What I don't understand is how each is referenced in osc. Where is the path for each image stored? How does osc know that xxxx.jpg goes here, ffff.jpg goes there etc.... In html each image is hard coded. ex.



D5..

Comment #17

Its in the database in the products table. you could write one line of code (probably) to fix it..... something like this. but you better backup and practice first for your specific cart! you will need to use PHPMYADMIN to execute..

THIS IS JUST AN EXAMPLE OF A "FIND & REPLACE" SQL statement! not actual path values!!!!!!.

UPDATE `products` SET `products_image_small` = '/catalog/images/small/' WHERE `products_image_small` = '/catalog/images/';.

This post has been edited by.

Carrerarod.

: 04 July 2004, 17:04..

Comment #18

One suggestion by 'mibble' above suggested I optimize my css file. Any suggestions on this one? What, take out what's not used? That's the only way I can figure to make it a smaller file? If so, how do you tell what's being used and what' not?.

D5.

I am manually adding the optimized images. Only 700 to go!..

Comment #19

You might want to leave your style sheet alone. Your work on the image sizes will pay off in dispay times. What you would gain by removing white space from the stylesheet will probably be offset by accidently removing some stray character, and having to go on the hunt to find it...

Comment #20

Yes I was concerned about what to take out and what not..

The following was posted elswhere concerning the speed issue:.

'This may have more to do with the performance of your Mysql installation than it does with OSC. On a good server 300-400 queries per second is a good average, on a bad server, 100 queries per second would make OSC take all day to load. I would also make sure your host has Zend optimizer or similar PHP performance booster installed. You may also wish to check your PHP.INI file and make sure you have more than 2megs lol, set aside for application use. '.

And my response:.

'A number of question..

How do I tell the # of queries going on?.

Where is the php.ini file located?.

How many megs should it be?.

Using Lunarpages..

This backend stuff is all new to me.'.

I never did gat an answer to my questions. Are these valid concerns?.

Thanks.

D5..

Comment #21

There are very few iPage hosting companies that do not have php properly installed..

Create this in a text editor.

Phpinfo();.

Name the file phpinfo.php.

Upload to your server and run...

Comment #22

Ok, did that. Now what do I do with all this info??? And how does it relate to speed???.

D5..

Comment #23

Hi,.

The SQL code Rodney supplied is the way to go (with mods as needed)..

Try it for just one product, by appending "limit 1" to the SQL statement..

Edit:.

Oops, sorry, I'm about 10 posts behind..

Peter.

This post has been edited by.

Peterr.

: 05 July 2004, 01:21..

Comment #24

Probably nothing. (not a smart aleck answer, either). What is does is show you what versions of Apache, php and mySQL your iPage hosting company is using, that register globals is on, safe mode is off, probably that majic quotes are on, what version of Zend scripting is being used, and a few other things..

Main use is if you get some strange errors, it may give you a clue to something that needs to be changed on your server...

Comment #25

Thanks. Now back to the SPEED issue. (did we ever leave?) Pages that have the optimized images are considerably faster at dial-up speeds. I've tried to limit the number of images per page. What more can I do?.

D5..

Comment #26

Hi,.

There are some contributions that apparently make a difference to the database and help somewhat. Possibly it is this one ? .

Http://www.oscommerce.com/community/contri...search,optimise.

Peter..

Comment #27

Thanks, that one has the text description, but no file attached...

Comment #28

Thomas,.

Did you download both, because the first one (up top) had something like 'minor corrections". indicating a minor update, in addition to the original ??.

Peter..

Comment #29

I got it. Thanks. When I first followed the link, neither one showed up. Cleared my cache and they showed. Will check out this pm..

Thanks..

Comment #30

Hello. I am having trouble with the page loading speed using osc. My current html based iPage site will load a pg with 10 thumbnails and several gifs in about 1 minute at 56k. My new osc based iPage site will load the catalog pg with only 7 thumbs and 2 gifs in 3 MINUTES 45 SECONDS at 56k!!!! This obviously is unacceptable. I installed thumbnail generator but I see no noticeable improvement. I have over 1k of images total, with one category having 250 thumbs.

Speed is my remaining issue before switching to the new site. Any help would be appreciated..

Thanks.

D5..

Comment #31

Yes, cache is 'on' and gzip 1.

Ps. why can't I edit my own posts??.

D5..

Comment #32


This question was taken from a support group/message board and re-posted here so others can learn from it.