Kryptronic Software Support Forum

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.

#1 02-28-2005 18:21:19

aposcovsky
Member
Registered: 03-28-2004
Posts: 2

Stopped Using The Program Because

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

 

#2 02-28-2005 18:44:42

EagleWolf
Member
From: Daytona Beach, FL
Registered: 07-27-2003
Posts: 979

Re: Stopped Using The Program Because

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. 


Chris
<a href='mailto:webmaster@equivity.com'>webmaster@equivity.com</a>
-

Offline

 

#3 02-28-2005 18:52:41

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Stopped Using The Program Because

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

 

#4 02-28-2005 19:07:48

dtwg
Member
From: California
Registered: 11-15-2004
Posts: 1339
Website

Re: Stopped Using The Program Because

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

 

#5 02-28-2005 19:44:29

Graham
Member
Registered: 09-30-2004
Posts: 981
Website

Re: Stopped Using The Program Because

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

 

#6 02-28-2005 20:36:33

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Stopped Using The Program Because

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

 

#7 02-28-2005 22:28:30

Quizno
Member
Registered: 06-02-2003
Posts: 447

Re: Stopped Using The Program Because

Duplications in the first row of the table

Do you mean the first column of the table?

Offline

 

#8 02-28-2005 22:40:50

EagleWolf
Member
From: Daytona Beach, FL
Registered: 07-27-2003
Posts: 979

Re: Stopped Using The Program Because

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.


Chris
<a href='mailto:webmaster@equivity.com'>webmaster@equivity.com</a>
-

Offline

 

#9 03-01-2005 06:29:08

Graham
Member
Registered: 09-30-2004
Posts: 981
Website

Re: Stopped Using The Program Because

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

 

#10 03-01-2005 08:25:50

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Stopped Using The Program Because

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

 

#11 03-01-2005 08:28:58

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Stopped Using The Program Because

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

 

#12 04-19-2005 10:24:35

janewest
Member
Registered: 05-11-2003
Posts: 79

Re: Stopped Using The Program Because

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

 

#13 04-19-2005 10:31:00

dtwg
Member
From: California
Registered: 11-15-2004
Posts: 1339
Website

Re: Stopped Using The Program Because

Are you running your product table in CSV or RDBMS/MySQL mode?

Dave

Offline

 

#14 04-19-2005 16:09:29

janewest
Member
Registered: 05-11-2003
Posts: 79

Re: Stopped Using The Program Because

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

 

#15 04-19-2005 17:18:35

dtwg
Member
From: California
Registered: 11-15-2004
Posts: 1339
Website

Re: Stopped Using The Program Because

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

 

#16 04-20-2005 15:05:33

janewest
Member
Registered: 05-11-2003
Posts: 79

Re: Stopped Using The Program Because

I do have mysql installed on my server. Now that I know that what should I do...

Offline

 

#17 04-25-2005 17:55:48

janewest
Member
Registered: 05-11-2003
Posts: 79

Re: Stopped Using The Program Because

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:tongueg 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

 

#18 04-26-2005 07:38:58

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Stopped Using The Program Because

You're selecting the PostgreSQL module.  Instead, choose the MySQL module.


Nick Hendler

Offline

 

#19 04-26-2005 10:30:03

janewest
Member
Registered: 05-11-2003
Posts: 79

Re: Stopped Using The Program Because

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

 

Board footer