Member Avatar for JeremyNZ

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

  • 3 Contributors
  • 3 Replies
  • 94 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by whatanidea
Member Avatar for omol

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.

Member Avatar for JeremyNZ

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

Member Avatar for whatanidea

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..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.