You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
I purchase the ccp51 prgogram a year ago. I work long hours putting item on the site.
Customer stopped doing business with me with a week.
The pages load very slow and it is hard to make the site look as I want it.
It takes a minute or two per item to load and as long to remove from the site.
And now I can't get into my admin part because it just stopped working.
I removed the jpg files to file it load faster.
I went back to my old way and the sells jumped from zero with the shopping cart to five a week.
Here is the poor site:
Here is the site that people like:
Offline
It is very hard to blame a shopping cart for server performance.
However, I would ask you a few questions.
What is the specs of your server, and do you have the cart set up to use mysql?
As for having your cart look how you want... well let me dispel any controversy on that. I have a strong design business doing just that, and the cart is very flexible - if you know what you are doing.
If you truly want to use CCP, and I sure there are many long time users on this forum, which will help you with the performance issues of your cart.
Offline
Chris is right in everything that he has said! I will add one more thing: If you have any duplication in your product.csv, it will bring the server to it's knees while it is trying to find the products to display.
Offline
I went to your CCP site and it was maybe a little slow -- like what you'd expect running in csv mode -- but not bad. It sure didn't take a minute to load anything. Without any graphics, it is impossible to tell what kind of effect they are having on load speed.
Running in RDBMS mode with MySQL, my CCP site is *much* faster than my old cart. It is also a heck of a lot more friendly to modify to look the way I want. You are entitled to your opinion of course.
Lastly, there are tons of reasons that any particular customer might perceive your site as being slow when it really isn't -- routing issues, their 9600 baud modem P2 166 Win 95 PC, their cut rate ISP, sunspots, telco issues, etc. It seems almost fast enough to me.
For what it's worth.
HTH,
Dave
Offline
TerryA,02/28/2005 06:52:41 PM wrote:
If you have any duplication in your product.csv, it will bring the server to it's knees while it is trying to find the products to display.
Could you explain this a little further, do you mean just duplicated products/ product references or is there more to it than that?
Offline
Duplications in the first row of the table are a definate no no as this is the index key for the record. If you have duplicate index keys, the script has a hard time figuring out which one to send to the display script.
Offline
Duplications in the first row of the table
Do you mean the first column of the table?
Offline
But if you convert from csv to mysql, ccp will not let you import duplicate index keys. At least I have had plenty of imports stop becuase of that. So I think there is a safe guard in ccp for that.
Offline
TerryA,02/28/2005 08:36:33 PM wrote:
Duplications in the first row of the table are a definate no no as this is the index key for the record.
Ok, just checking that was what you were referring to.
It should also be pointed out that duplicates in the first column will also cause problems
[Addendum] Ah, just spotted the next messages in the thread! :-)
Offline
Quizno,02/28/2005 10:28:30 PM wrote:
Do you mean the first column of the table?
Sorry, I meant column! It was a long day yesterday and my brain had fried!
Offline
EagleWolf,02/28/2005 10:40:50 PM wrote:
But if you convert from csv to mysql, ccp will not let you import duplicate index keys. At least I have had plenty of imports stop becuase of that. So I think there is a safe guard in ccp for that.
I believe that the safeguard may be built into MySQL, although I have converted tables to csv and was unable to convert them back to tables because there were duplicates that MySQL had allowed.
Offline
Hi, I am having similar sluggish load times even on high speed connection. Where do I go to see if my problem is the one you describe here? What file and in which folder would it be???
go to:
then click on any of the flashcards, or go to:
kind regards for any answer.
Karen
aka janewest
Offline
I dunno. But once I took off page accessing, which I should be tracking for my client, load time accelerated. I am not database savvy. I am using default settings.
Offline
I suspect that if you were to run some key tables in RDBMS/MySQL mode, your site would become dramatically faster (even with page access logging enabled). It's (usually) not too difficult to set up CCP to use MySQL. You don't really need to be database savvy. :-)
First, find out if your web host offers it on your account and if so, what your username and password is. Then set up the connection using Admin > Database Utilities > Configure RDBMS Connection. Then you can convert most or all of your tables to use MySQL (there are some possible issues with sorting on certain tables that may or may not apply to you).
Let us know if you get stuck and need help.
Dave
Offline
I do have mysql installed on my server. Now that I know that what should I do...
Offline
Okay, I really need help with configuring the Database aspect. Mysql is installed but when I type in the info for Configure RDBMS Connection this is what I get:
ERROR: A connection could not established with the relational database you selected using the configuration information you entered.
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /modules_lib /usr/local/lib/perl5/5.8.4/i386-freebsd /usr/local/lib/perl5/5.8.4 /usr/local/lib/perl5/site_perl/5.8.4/i386-freebsd /usr/local/lib/perl5/site_perl/5.8.4 /usr/local/lib/perl5/site_perl/5.8.3/i386-freebsd /usr/local/lib/perl5/site_perl/5.8.3 /usr/local/lib/perl5/site_perl/5.8.1/i386-freebsd /usr/local/lib/perl5/site_perl/5.8.1 /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.005 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/vendor_perl/5.8.4/i386-freebsd /usr/local/lib/perl5/vendor_perl/5.8.4 /usr/local/lib/perl5/vendor_perl/5.8.3/i386-freebsd /usr/local/lib/perl5/vendor_perl/5.8.3 /usr/local/lib/perl5/vendor_perl /usr/local/lib/perl5/5.00503 /usr/local/lib/site_perl . /modules_inc /modules_dbi) at (eval 10) line 3. Perhaps the DBD:g perl module hasn't been fully installed, or perhaps the capitalisation of 'Pg' isn't right. Available drivers: AnyData, DBM, ExampleP, File, Proxy, Sponge. at /library/common/database.pl line 366
I am using phpmyadmid for managing my databases. I added a database called nsStore, but don't know how or what to do from there. I am using localhost for hostname, root and password set up by me server host (Verio). What am I not doing right???
Offline
HI Nick,
When I choose MySQL I get a similar error as above.
ARGGGGGGGGGGGH! I will call verio support and find out what is wrong with the mysql configuration. Whish me luck!
Karen
Offline