mysql mod?

[davidstummer]

i would greatly appreciate some help modding my database, as right now it just isn't easy enough to input all my data.

 

here is the situation:

i will have about 10 million products, BUT i have a default description for each on my site, so no description needs to be uploaded. also no picture needs to be uploaded. there is one of each, so the default quantity has been set to 1. the product model is the same as the product name.

 

the 3 tables affected are products

products_description

products_to_catergories

 

i use SSH to upload to each of these tables.

 

QUESTION

is there anyway to upload to all 3 tables at once (ie using one csv file with the data in)? how could you incoroporate all three tables into one big table? would this work?

 

what is the product id used for? how can you replace the product id, with the product model? is thw id linked to many things?

 

i am saying this, because the product id is automatically created, so it will be very hard for me to keep track of millions of products (numberplates).

 

instead of having a products to catergories table, could you not just add catergories onto the end of the products table?

 

 

thankyou, dave :shock:

[Daemonj]

i would greatly appreciate some help modding my database, as right now it just isn't easy enough to input all my data.

 

here is the situation:

i will have about 10 million products, BUT i have a default description for each on my site, so no description needs to be uploaded. also no picture needs to be uploaded. there is one of each, so the default quantity has been set to 1. the product model is the same as the product name.

 

the 3 tables affected are products

products_description

products_to_catergories

 

i use SSH to upload to each of these tables.

 

QUESTION

is there anyway to upload to all 3 tables at once (ie using one csv file with the data in)? how could you incoroporate all three tables into one big table? would this work?

You could do that but you would not want to.

 

It would be better to just edit your text file for the product description and the product_info.php page for the image. That way you would not waste disk space in your database by storing the same description and image for every product.

 

Not to mention making a change would be a lot easier and faster.

 

what is the product id used for? how can you replace the product id, with the product model? is thw id linked to many things?

The product_id is a unique identifier for each record. Yes the product_id is linked to a lot of things.

 

i am saying this, because the product id is automatically created, so it will be very hard for me to keep track of millions of products (numberplates).

What is so hard about it - the system automatically assigns it. You are going to have a harder time with keeping your model numbers unique.

 

instead of having a products to catergories table, could you not just add catergories onto the end of the products table?

You could but then the database would not be "normalized".

[davidstummer]

what do you mean by normalised?

 

p.s. my shop is based around the search tool, the catergories box isn't even displayed.

 

http://www.no-1-plates.com/catalog/product...1855fe743e61028

[Daemonj]

what do you mean by normalised?

It is a little too involved for me to explain here. Do a search for database normalization at google and you should find some relevant information.

 

p.s. my shop is based around the search tool, the catergories box isn't even displayed.

http://www.no-1-plates.com/catalog/product...1855fe743e61028

That really does not have much of an effect on what we are discussing. Your database will still serve the information regardless of how it is accessed.

 

In addition, if you modify the database too much you will run into troubles with later updates/versions of osC.