1, the data on the cloud server, capacity of more than 10 g, more than 15 million records
Currently, only one table, and field types are as nvarchar (50),
2, through the computer desktop applications that allow users to surf the Internet, query and upload data, consider the retrieval speed, upload and download considering the encryption
Solution:
1, the choice of the database and reason,
Choose SQL SERVER or MSSQL or DB2 etc.
2, the query and the choice of the ways of uploading data and implementation difficulty, and explain the reasons,
A. directly through the access to the cloud SERVER database, for example: SQL SERVER 2008 by IP address, port, login name and password to access the database directly, (this I can implement)
B. send and return the data by XML
C. other ways
CodePudding user response:
Large amount of data interaction, or set up a local database, otherwise too boring,CodePudding user response:
1. Database selection,Are you familiar with the good, you this is only a table, and simple structure, is essentially, mysql isn't so different from,
2. Consider speed, that is, of course, with the database directly, many interface must be slower,
Tell from security, can be used webapi,
CodePudding user response:
Essentially, mysql isn't so different from,