Is there any reference guide to how the database size is affected by the sections, products and attributes we add to the store?
With quite a large store (10,000 products), I always have my eye on overall database size, and am aware of the maximum access size of 2GB.
I also understand that number of orders stored is a factor too, and understand how database compaction works.
What I am trying to work out, is how much data I can afford to cram into my store, before it goes pop.
With the revamp I am working on, I would like to add a number of custom variables to my products, to enable more advanced searching (by author, genre, publisher etc).
I would like to have an idea of how adding each additional variable will affect the size of my database.
I realise this is a bit of a "how long is a piece of string" question, but is there some way of calculating this?
For example, if I add a custom variable called "author" with an average field size of say 20 characters, to 10,000 products, what is the net effect on the size of the DB.
If all products have the custom variable, but only half of then have an entry in the field (the other half still have the variable, but its left blank), how much space is then used?
This is one for the database experts, so I probably should be posting this in a different forum (CD - please feel free to move it if appropriate), but lets see if anyone has some answers.
I did try to work this out by adding products to a test site, and checking how the dbf size changed, but the results are inconsistent (eg adding 1 product can add X KB, but adding another identical product adds Y KB!).
With quite a large store (10,000 products), I always have my eye on overall database size, and am aware of the maximum access size of 2GB.
I also understand that number of orders stored is a factor too, and understand how database compaction works.
What I am trying to work out, is how much data I can afford to cram into my store, before it goes pop.
With the revamp I am working on, I would like to add a number of custom variables to my products, to enable more advanced searching (by author, genre, publisher etc).
I would like to have an idea of how adding each additional variable will affect the size of my database.
I realise this is a bit of a "how long is a piece of string" question, but is there some way of calculating this?
For example, if I add a custom variable called "author" with an average field size of say 20 characters, to 10,000 products, what is the net effect on the size of the DB.
If all products have the custom variable, but only half of then have an entry in the field (the other half still have the variable, but its left blank), how much space is then used?
This is one for the database experts, so I probably should be posting this in a different forum (CD - please feel free to move it if appropriate), but lets see if anyone has some answers.
I did try to work this out by adding products to a test site, and checking how the dbf size changed, but the results are inconsistent (eg adding 1 product can add X KB, but adding another identical product adds Y KB!).
Comment