Coder

WITH inactive_connections AS ( SELECT pid,client_addr, RANK ( ) OVER ( PARTITION BY client_addr ORDER BY backend_start ASC ) AS RANK FROM pg_stat_activity WHERE pid <> pg_backend_pid ( ) AND...

SELECT to_char(b,'YYYY-MM') AS time FROM generate_series (to_timestamp ( '2018-01-01','YYYY-MM-DD hh24:mi:ss' ),to_timestamp ( '2018-12-07','YYYY-MM-DD hh24:mi:ss' ),'1 days' ) AS b GROUP BY TIME ord...

在给客户开发的门户网站中用到了整站搜索功能，在上线一年多后，在将近20个频道中（20张表），由于数据量越来越大，从而导致关键字搜索越来越慢，搜索一次将近20s的时间。所以最近决定优化搜索模块！

使用NuGet引用MongoDb.Driver static void Main(string[] args) { MongoDbHelper<MongoTestEntity> db = new MongoDbHelper<MongoTestEntity>(); var model = new MongoT...