We’re students from the TU Delft working on a project where we have to choose from certain database or other ways to store information about publications. Now we have to decide based on several criteria, one of which is speed to access the data over the internet. The options we’re considering are:
C C++ Delphi Java MySQL MS SQL MS Access Oracle PHP
Please don’t spend your time on telling us which one to choose, just this: could someone grade all of these systems on their speed, 10 being the fastest one, 0 for the slowest. Thank you!
I think you meant Access alone, without any HTML/*SP/PHP front end does not work over the internet. SQL Server has a similar problem, since folks started shutting down port 1434 UDP on all their routers. How advisable it is to expose an Access database or a SQL Server to the internet sans firewall may be up for another debate, not included in this question.
I had this discussion already with someone else in an Oracle topic, but we have to make a list of possible solutions, and in the end we will choose a combination of them (very likely based on our criteria it will be Java/MySQL). But what we will be comparing it with is two pipes, connected in series. If the one pipe is incredibly thin (for example MS Access), you can have the biggest pipe in front of it, it won't help you. So we are not comparing them as much as it may seem here, we just want to know where a bottleneck might be.