. NET medium and large project development essential -- efficient paging

Related downloads: DeveloperSharp.dll component DeveloperSharp.dll component Efficient paging - sample code (dp8 paging. RAR)Efficient paging - sample code (dp8 paging. RAR)   Data paging is a necessary function of almost any application system. However, when the amount of data is large, the efficiency of paging operation will become very low. ...

Added by santhosh_89 on Fri, 21 Jan 2022 12:16:09 +0200

TiDB source code reading: generation of physical plan

Copyright notice: This article is compiled by the team of Digital China cloud base. If you reprint it, please indicate the source. preface I don't know how many days have passed since the last source code learning note. You may think I've gone from entry to soil, but I didn't! I'm still studying hard! There are a lot of things to deal with i ...

Added by adguru on Fri, 21 Jan 2022 10:23:18 +0200

Oracle Installation and Details

Installation steps 1. Install dependent packages Operating user:root yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.d ...

Added by BAM1979 on Fri, 21 Jan 2022 07:34:31 +0200

Task02: SQL basic query and sorting - Tianchi Longzhu plan SQL training camp

1, SELECT statement basis select <Listing>, from(Table name); where <Conditional expression> Correlation rule An asterisk (*) means all columns.Line breaks can be used in SQL at will, which does not affect the execution of statements (but empty lines cannot be inserted).When setting Chinese aliases, you need to use double qu ...

Added by kcgame on Fri, 21 Jan 2022 03:13:52 +0200

monggo index optimization

mongodb index rule Mongodb's indexing rules are basically the same as those of traditional relational databases. Most techniques for optimizing MySQL/Oracle/SQLite indexes are also applicable to mongodb. Why index When some conditions are used in the query, the key can be indexed to improve the query speed.When the amount of data is lar ...

Added by MrRosary on Fri, 21 Jan 2022 02:35:41 +0200

SequoiaDB high availability cluster deployment of database Series

SequoiaDB, as a storage engine, supports high concurrency HTAP scenarios. The standard summarizes the high availability deployment practice of using SequoiaDB as data storage in the operation and maintenance analysis project, and accesses Kafka for high concurrency update business and Spark for high concurrency batch query business. SequoiaDB ...

Added by mrtechguy on Thu, 20 Jan 2022 22:51:59 +0200

c# operation files are stored in the database (in binary form)

In the process of development, we often encounter the form of storing files in the database. The common method is to upload files to the server. The database only needs to save the file path address. However, many internal window applications are not linked to the network and are local running services. At this time, we need to use another form ...

Added by twister47 on Thu, 20 Jan 2022 20:06:42 +0200

Installation and python operation of document database-1-[MongoDB] in windows

reference resources Python operates MongoDB. Just read this article 1. Install MongoDB windows download address of mongodb MongoDB provides precompiled binary packages. (1) Download msi file. After downloading, double-click the file and install it according to the operating instructions. During installation, you can set your installation dir ...

Added by Lagreca on Thu, 20 Jan 2022 16:16:53 +0200

Mysql - related functions

*Blog home page ——Xiaojie's blog home page to cheer *Welcome to pay attention to likes collection messages *Just learned, if ## title is wrong, please correct it! Function table: 1. Statistical total functioneffectCOUNT(*)Returns the number of rows of records that meet the criteriaCount (column)Returns the number of rows, but ...

Added by leightons on Thu, 20 Jan 2022 12:41:08 +0200

Connect to Damon database in QT Create OCI mode

Connect to Dameng database in QT OCI mode 1, Background The user uses QT Create to develop the integration software OCI to connect to the database. And adaptation Center https://eco.dameng.com/docs/zh-cn/app-dev/index.html There are no relevant examples, and the examples on the official website are old, so share them. It should be noted that ...

Added by phpnewbie81 on Thu, 20 Jan 2022 04:10:39 +0200