Add Pages to Site or not?

[jb123]

Should I add additional pages to my site? If we offer products via our web site and want to create a database and/or page types for each of our products, what database would we be BEST served to use for getting the pages indexed and RANKED in google? Each product would represent one new page with pricing and a little information on the particulars about the product. Is that good enough content per page? We have over 700,000 items to offer BUT obviously could not create something that huge, we would just start it and take one product at a time in hopes that we could get a 5,000 to 10,000 products to proesent on our web site. Should we link each page back to the homepage? Should we use a subdirectory then, a product name as the file name (i.e. www.widgets.com/widgets-catalog/blue-widgets.html)?Please any thoughts or ideas would be greatly appreciated.

[mbennie]

If you want to add a page for each product and intend to use a database, why not just build one asp/php/perl page that calls the product from the DB? You can have all 700,000 products listed in about a day.

[jb123]

See obviously I don't know much about this topic because I had no idea I could have all 700,000 items in a database in one day. I have heard of all three: ASP, PHP, PERL but I guess my next question would be what are the pros and cons for each, what is the best system and easiest to work with as a novist and what would the cost be and which one is best in getting indexed and ranked by Google to help with a web sites content and size? Thank you in advance for your response.