Quote:First for companies like Facebook, YouTube, Instagram and
other companies' database processing to report SQL Server
The communication line is given to our web server
User information is available on this server by
user information to access database data or fetch user-related files.
We get to the point where the user posts the files every day
we store On the database of a computer in the internal network
that has a hard drive with a raid strip.
There is a Windows service on this computer whose job is to
distribute the database table data on computers within the network
up to 100 computers for storage and the computer ip stores the
storage in the table of a computer that is to be extracted.
To identify a suitable computer for distributing the file on it,
it looks at the active IP table and, for example,
if there are 10 active computers,
stores it on one of the ten to be taken And returns the IP
to store the record with the ID on the database of that particular computer.
Now you can use the server link to report or obtain files
The id of the file is stored on a table with ip of computer that stored on back to the server and store
on the on table that inner join with table of users
Now, when the user logs in, his data will be accessible.
Having the IP address of the link server and the ID of
the file storage location, the report can be get with dynamic queries
Microsoft sql server and the speed of getting files depends
on how many of network computers
Windows service must clear the data from its table after saving the data on
the SQL Server database to always serve the file senders with