Kryptronic Software Support Forum

Stefan · 04-11-2005 09:42:27

I am just setting up our store and am wondering which database to use CSV or MySQL. I know how to select which one, the question is which one is the best for me?

I ask because we will probably have quite alot of products in the long run and I would rather use MySQL now if I am going to have to change to it in the long run anyway.

If someone could let me know what the difference is and which one they think I should go for please.

I know CSV stands for Commar Separated Values (or something like that anyway) which I believe is good for packages like Excel etc. but I just a bit stuck for what to go for.

Thanks.

JBell · 04-11-2005 09:45:16

If you have a lot of products, you will want to operate in MySQL mode. CSV will cause your site to run slow with a lot of products.

TerryA · 04-11-2005 10:41:25

Your host will also like you a lot better if you run in MySQL! Less load on his server!

dtwg · 04-11-2005 10:50:26

It doesn't have to be a permanent decision. A lot of us switch back and forth quite often, as it can be much faster to do bulk adds of new products using Excel vs. the CCP Admin. It goes something like this:

Run in MySQL mode most of the time.
Switch to CSV when getting ready to do updates.
Download CSV file and update in Excel.
Upload updated CSV file.
Switch back to MySQL mode.

HTH,

Dave

JBell · 04-11-2005 11:21:35

TerryA,04/11/2005 11:41:25 AM wrote:
Your host will also like you a lot better if you run in MySQL! Less load on his server!

Hehehe, is that a hint for me to switch my CSV database to MySQL, Terry?

Stefan · 04-11-2005 12:38:00

Thanks guys. That was really helpful to me. I can now get cracking.

TerryA · 04-11-2005 18:58:15

JBell,04/11/2005 11:21:35 AM wrote:
Hehehe, is that a hint for me to switch my CSV database to MySQL, Terry?

If you want to take it as that!!! :-)

shibumik · 04-11-2005 22:30:57

Aside from dramatically increased performance, MySQL can be manipulated by other languages far more efficiently than CSV. In short, MySQL is easier to create modules to extend your environment and is dramatically more efficient.

10,000 records in CSV will suck away your server's desire to live!

TerryA · 04-12-2005 07:07:30

Then, if you happen to have a couple duplicate records, you can hold the funeral!

myfunkyshop · 04-12-2005 08:15:38

Hi there,

I have lots of products on my website how do i convert my site to mysql.... Please can someone give me instructions..

Thank you

TerryA · 04-12-2005 08:29:45

There are instructions in the manual on how to set it up. Briefly, you will first set up a database for your site. How this is done depends on the type of server you are on and what database management software the server has on it. You may want to consult with your host on this part. Also, check with your host to see what the hostname for connecting to the database is. When you create the database, remember the database name, user name and password that was assigned to the database. Then go into CCP admin and navigate to the section called Database Utilities. From there, go to Configure RDBMS Connection and select the type of DB software available to you. The next screen will ask you for the database information. In the spot for hostname, try putting localhost and see if it works. If it does not, use the name the host provided you. Once the database connection is made, go to Manage Table Data Sources in the menu and select Change beside the tables you want to move to the database.

Have fun!

myfunkyshop · 04-12-2005 08:40:36

Hi there TerryA,

I think i have cracked it???

Does this mean that i now have my website on mysql

CONFIRMATION: Thank you. A successful connection was made using the configuration information you entered. You can now configure tables to use this RDBMS connection.

My website now runs faster!!!

Thank you for the point in the right direction.

TerryA · 04-12-2005 13:51:39

You have made the connection to the database but you need to go to Manage Table Data Sources and switch the tables from csv to MySQL. If you have done this, then you are running in MySQL mode.

Stefan · 04-12-2005 19:09:46

WHOOOSH! What a massive change in speed. MySQL is much better. Thanks for all your help/opinions. I am glad I changed to MySQL.

Kryptronic Software Support Forum

#1 04-11-2005 09:42:27

Csv - Mysql

#2 04-11-2005 09:45:16

Re: Csv - Mysql

#3 04-11-2005 10:41:25

Re: Csv - Mysql

#4 04-11-2005 10:50:26

Re: Csv - Mysql

#5 04-11-2005 11:21:35

Re: Csv - Mysql

TerryA,04/11/2005 11:41:25 AM wrote:

#6 04-11-2005 12:38:00

Re: Csv - Mysql

#7 04-11-2005 18:58:15

Re: Csv - Mysql

JBell,04/11/2005 11:21:35 AM wrote:

#8 04-11-2005 22:30:57

Re: Csv - Mysql

#9 04-12-2005 07:07:30

Re: Csv - Mysql

#10 04-12-2005 08:15:38

Re: Csv - Mysql

#11 04-12-2005 08:29:45

Re: Csv - Mysql

#12 04-12-2005 08:40:36

Re: Csv - Mysql

#13 04-12-2005 13:51:39

Re: Csv - Mysql

#14 04-12-2005 19:09:46

Re: Csv - Mysql

Board footer