SQL Server big data processing-tutorial

Source: Internet
Author: User
The original data structure is 12 databases. Each database has 100 tables, which are stored in clusters of QQ groups. I create a new structure and generate a new relational table, it is estimated to be 1.4 billion million data records (which may not be reached). I want to determine the size of the QQ number to insert different databases and tables, with 15 databases, 100 tables per database ,...

The original data structure is 12 databases. Each database has 100 tables, which are stored in clusters of QQ groups.

I made a new structure to generate a new relational table, which is expected to be 1.4 billion pieces of data (which may not be reached). I want to determine the size of the QQ number to insert different databases and tables, respectively, there are 15 databases, 100 tables in each database, a total of 1500 tables, 1 million data records in each table, the table has been generated (), and now the data is inserted, I used PHP yesterday to process a table. It took nearly 15 minutes to run. This is too slow. Is there any better way?
This is the program we made yesterday. Which of the following experts gave me some advice and optimized it. The experts helped me with the job I just got started with. On the third day, I couldn't help but leave.

Reply content:

The original data structure is 12 databases. Each database has 100 tables, which are stored in clusters of QQ groups.

I made a new structure to generate a new relational table, which is expected to be 1.4 billion pieces of data (which may not be reached). I want to determine the size of the QQ number to insert different databases and tables, respectively, there are 15 databases, 100 tables in each database, a total of 1500 tables, 1 million data records in each table, the table has been generated (), and now the data is inserted, I used PHP yesterday to process a table. It took nearly 15 minutes to run. This is too slow. Is there any better way?
This is the program we made yesterday. Which of the following experts gave me some advice and optimized it. The experts helped me with the job I just got started with. On the third day, I couldn't help but leave.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.