Hi There.

I'm just hoping someone can answer a question for me, as although i have been a IT Network Administrator for a long time, I know very little about web design/database design.

I'm currently in the process of setting up a website to will contain a very large amount of data so I'm seeking advice on the best type of database to use for this website.

The site will be a financial site containing information on prices of products for each country that I have information on. I want to have the site setup so you can select a country from a dropdown box that will then autofilter the available products for that country. Once the product is selected, I am wanting web viewers to be able to select another country and product from separate dropdown boxes to compare the prices of the product for each country. Although the options sound basic at the moment, I would like it to be more complex going forward so prices of a product today can be compared with the price of the same product 10 years ago etc.

As this data is likely to change a lot (inflation etc), I will hopefully be using a live feed after the site gets going, so can someone please recommend a good database system to use for this sort of information. I have been advised My SQL is good but can slow down the site if there is too much information in the database.

I might not be able to use a live feed of this data for a while so if the data remains historical for a while and required manual data entry, would this make a difference on the type of database I use?

Thanks heaps for you help and let me know if you require more information.
Cheers, Jeremy

Any database will do this, and database speed is genrally relient on hardware rather than the database tech. I am a huge fan of MySql and CORBA for speed. But enless your talking in gig being transfered you won't really notice atall.

If you had handed this project to me i can pretty much guarentee i would have done it using MySql and PHP especial if it's web based.

It sounds very similar to some kind of price comparison site?

Just out of intrest are we talking about millions of rows or just thousands.

All i can reccomend is read up on each database tech. The main 3 being MySql, MsSql and MySqli. All will do what you have explained here with ease.

Cheers OMOL

Big help. It should only be in the thousands so will look into these database types and PHP.

Thanks for your help

Cheers, Jeremy

friend i have been developing web based apps and websites on ms .net technologies from last 3 yrs or so.. and i have never faced any issues with the .net and sql servers.. though one catch is there.. u have to spend money on buying hosting and sql servers.. but again the robustness and scalability is really cool in .net as far my knowledge..