Tag：data base
-
Time：2021-9-24
For a game, with the growth of users, the increasing amount of data is inevitable. At this time, the database needs to be expanded. For tcaplusdb, the expansion and contraction of its storage layer tcapsvr is the only way for operation and maintenance, and tcaplusdb provides OMS to facilitate operation and maintenance personnel. Tcapsvr expansion […]
-
Time：2021-9-24
In the last note about using ent ORM quickly, we started using it againentc init UserCreate a schema. The schema in ENT ORM is actually a database model. In the schema, we can define the field information of the table in the database through fields; Define the relationship information between tables through edges; Define the […]
-
Time：2021-9-24
1、 Introduction to SQL Server insertion scheme aboutSqlServerThere are three common insertion methods for batch insertion,Insert、BatchInsert、SqlBulkCopy, let’s compare the speed of the following three schemes 1. OrdinaryInsertInsertion method public static void Insert(IEnumerable persons) { using (var con = new SqlConnection(“Server=.;Database=DemoDataBase;User ID=sa;Password=8888;”)) { con.Open(); foreach (var person in persons) { using (var com = new SqlCommand( […]
-
Time：2021-9-24
Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. He is good at backup and recovery, SQL tuning, monitoring, operation and maintenance, high availability architecture design related to MySQL, PostgreSQL, mongodb and other open source databases. At present, he works in aikesheng, providing MySQL related technical support and MySQL related […]
-
Time：2021-9-23
The article is “inside MySQL Technology: InnoDB storage engine (Second Edition)”Nuggets brochure “how MySQL works: understanding MySQL from the root”My notes Transaction overview In real life, we all have the following experiences (which is also one of the classic scenes of business): I have no money recently. I need to go to the bank to […]
-
Time：2021-9-23
Write in front With the increase of business volume, the company has fully accessed the project in recent monthsRedis, during the development process, it is found that there is a lack of specific practical data on the market, especially inNode.jsIn this environment, the information that can be found is either too simple to get started […]
-
Time：2021-9-23
preface On the one hand, database optimization is to find out the bottleneck of the system and improve the efficiencyMysql databaseOn the other hand, reasonable structural design and parameter adjustment are needed to improve the corresponding speed of users, and save system resources as much as possible so that the system can provide greater load […]
-
Time：2021-9-23
Consolidate legacy databases into Django Although Django is best suited for developing new applications, it can also be integrated into legacy databases. Django includes many tools to solve such problems as automatically as possible. This article assumes that you understand the basics of Django, which are mentioned in the tutorial. Once your Django environment is […]
-
Time：2021-9-23
Abstract: among enterprise customers, SQL Server still exudes lasting vitality in the traditional manufacturing industry. The CDC complexity of SQL server is lower than that of Oracle. Therefore, the standard official practice is to directly use this CDC interface for synchronization, but there are also people in the Jianghu who directly read database changes by […]
-
Time：2021-9-23
FBI terrorist list leaked A copy of the 1.9 million terrorist watch list managed by the FBI was exposed online for three weeks from July 19 to August 9, 2021, including confidential “no fly” records. In 2003, the FBI established a terrorist screening center (TSC) in response to similar 9 / 11 terrorist attacks. TSC […]
-
Time：2021-9-23
Introduction to laravel tinker In native PHP, you canphp -aThe command uses an interactive shell: # php -a php > $msg = “Hello world!”; php > print $msg; Hello world! php > $num = array_sum([1, 2, 3]); php > print $num; 6 In addition, you can usePsySH, compared with nativephp -a, psysh has more advanced […]
-
Time：2021-8-3
Database is very important. Without backup, you can only run away. So make a backup!Mysqldump backup1. Backup command Format: mysqldump – H host name – P port – U user name – P password – database database name > file name. SQL For example: mysqldump – H 192.168.1.100 – P 3306 – uroot – ppassword […]
