Hello, Our web content is running on a Windows based server and we are looking to implement a reporting database that will be used by over 200 individuals in 5 states, we are thinking of writing the database from scratch, but we are also considing using a pre-designed CMS, to save some time. I am familar with MySQL and PHP, and I am currently learning ASP, and windows based server applications. The database will become quite large and we need it to be able to handle around 4500 entires a day, so we are looking at size as well as security.
We need a database that we can secure and on that can handle this load. The database will be edited and data will be input via the internet, via a unlisted domain name.
Does anyone have any suggestions for an ASP beginner on this project or should I stick to PHP.
working hard is better then hardly working ...
I will try not to be too biased as I am a huge PHP supporter, especially over ASP. There are many sites and discussions on "the best" web scripting language... do a Google search on "PHP vs ASP" and you'll see
A few things I can think of is PHP is more portable, it can run on various systems and operating systems, as opposed to ASP which is the work of Microsoft. You won't see ASP running (happily) on linux, confining your ASP solution to a Windows-only platform which may raise issues with your concern for security. PHP is also completely free whereas I think ASP requires licensing? On the other hand, many will show disfavor for PHP as it is sometimes deemed "insecure"
My overall point is you can reach your goal with PHP or ASP, and make it fast, efficient, and secure - so I would recommend you stick with the language you know best - security issues are usually introduced by developer ignorance, so whichever you choose - read up on some best practices to writing secure applications... for instance with PHP, check out php|architect, its a great magazine
As for the database server, I don't see why MySQL wouldn't be a great solution for you - it can handle your proposed workload. My only experience is with MySQL and Oracle (which would be overkill), so I can't comment on other RDBMS like MS SQL, etc.
Also, take a look at PostgreSQL. It is a full-featured, open source (truly free) database with excellent performance and is scaleable.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert