New answers tagged web-hosting
What you are describing here is a classic example of a very simple relational database. Go, design your own. You can go for LAMP, or let's say MS Access.
Both ftp, and ftps are clumsy, outdated protocols. Find yourself a sftp provider (there are a few of them out there).
When transferring files data integrity is a high priority. We want the data to be the same on both the receiving and the sending parts. While encryption does not ensure integrity it does signal by becoming corrupt if it was changed mid stream. It does also help with privacy. Everything that can be learned about someone helps. If the data can be seen it can ...
The question is if the app scales well on multiple cores. I.e. is one user connecting to the server able to saturate all cores. Since we know little about the app itself, you would have to provide more detail, or do some tests with some load graph.
I think it depends on what is the resource utilization on your current system. Are you noticing CPU/Memory/Disk-IO/Network saturation or frequent spikes ? If yes then you will benefit with faster machine, otherwise I don't think it will make any noticeable difference. You should be able to see the difference by monitoring site latency from your webserver ...
Top 50 recent answers are included