Optimize. Net MVC to access pages slowly

Make a good ASP.NET MVC website, access speed is very slow, it takes several seconds to tens of seconds to display the page. Every dozens of minutes will occur such a situation. Below to share the optimization method.   The development environment is: VS2015 + IIS8+ SQL Server Deployment environment: Windows 2008 R2+ IIS7+ SQL Server   Set IIS ...

Added by Yesideez on Thu, 13 Jun 2019 21:18:44 +0300

Some properties of hibernate's set mapping

1. Set Mapping Collection Properties ​ attribute Explain Default value name Name of mapping class property access Hibernate's policy to access this property defaults to property table Associated Target Database Table chema schema name of the target database table catalog The catalog name of the targ ...

Added by Jnerocorp on Tue, 11 Jun 2019 20:43:24 +0300

Oracle DataGuard: Single-node to RAC cluster hosting environment setup

demand As business grows, data volume becomes more and more complex, data volume becomes larger and larger, and requirements for database and server performance, high availability, disaster tolerance become higher and higher.Taking the current database environment as an example, the size of Windows 2008 r2 server + NAS storage + Oracle11.2.0.1+ ...

Added by fwegan on Tue, 11 Jun 2019 20:20:08 +0300

Section 5: Dynamic SQL for mybatis

For some complex queries, we may specify multiple query conditions, but these conditions may or may not exist, such as finding a house on 58 Tongcheng, we may specify area, floor and location to find a house source, or we may specify area, price, household type and location to find a house source, at which point the user-specified bar is requir ...

Added by Rheves on Tue, 11 Jun 2019 19:50:18 +0300

SQL Server table structure (with constraints) replicates stored procedures

Various constraints in SQL Server and methods of querying various constraints using sql are introduced in the paper. Based on the above, table structure is implemented in this paper. (Contains constraints) The storage process of replication. The stored procedure is tested on SQL Server 2008 and SQL Server 2014. sql is as follows /********* ...

Added by ag3nt42 on Mon, 10 Jun 2019 22:47:39 +0300

Introduction and Summary of MS SQL Batch Generation Job Script Method

When migrating or upgrading SQL Server database servers, we cannot restore msdb in many scenarios, so we have to migrate SQL Server related jobs manually. If it is time-consuming and laborious to manually generate scripts for each job, there are actually several methods in SQL Server that can generate job scripts in batches. Here are some of th ...

Added by rachybaby on Mon, 10 Jun 2019 22:26:19 +0300

Set Operations

1) Overview The following articles have been published [SqlServer Series]: [SqlServer Series] SQLSERVER Installation Tutorial  [SqlServer Series] Three Database Paradigms [SqlServer Series] Form Query [SqlServer Series] Table Connections [SqlServer Series] Subquery [SqlServer Series] Turn on Sqlserver remote access This article ...

Added by ambo on Sun, 09 Jun 2019 20:37:23 +0300

Basic knowledge of Java JDBC (4)

Previously, I learned how to create a database tool class, as follows: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil { // Privatization Construction Method private DBUtil() { } private static String url = ""; ...

Added by CavemanUK on Sun, 09 Jun 2019 00:13:40 +0300

Introduction to MySQL Use

DDL, DML statements DDL (Data Definition Language) data definition language is to create, delete and modify the internal objects of the database; DML (Data manipulation language) is a data manipulation language, which operates on the data in the table. Create a database - CREATE Display the currently created database mysql> SHOW DATA ...

Added by Jumba on Sat, 08 Jun 2019 23:21:45 +0300

The Impact of Cluster Index on Data Insertion

background Developer feedback system is particularly slow to execute a stored procedure, which is checked because of the need to insert a large amount of data into the new task table during the execution of the stored procedure. The primary key of the task table is clustered index. Why does clustering index cause slow insertion? How much impa ...

Added by gwood_25 on Sat, 08 Jun 2019 00:05:03 +0300