1.先查询九百万条后的20条数据 就是下面这个语句. Select. from usertb limit 9000000,20. Mysql 的处理时间是3.09秒. Apply OS: Windows, macOS Apply Navicat Product: Navicat for MongoDB, Navicat Premium Apply Navicat Version No.: Version 12.1 or above You can use MongoDump & MongoRestore features to backup a. Navicat for MongoDB (Linux) version 12.1.5. Bug-fixes: Minor bug fixes and improvements. To upgrade, please visit our Customer Center.

  1. Navicat For Mongodb Pc
  2. What Is Mongodb Good For
  3. When To Use Mongodb
  4. Navicat For Mongodb Mac
Aug 10, 2018 by Robert Gravelle

The term 'NoSQL' actually encompasses a wide variety of different database technologies that were developed in response to the demands dictated by modern applications and Internet of Things (IoT) devices. The massive volumes of new, rapidly changing data types created by the linking of numerous systems and devices have presented challenges for traditional DBMSes:

  • Relational databases were never designed to cope with the scale and agility challenges demanded by modern applications

  • Nor were they built to take advantage of the cheap storage and processing power available to today's servers.

One of the most popular NoSQL databases is MongoDB. In fact, it's the leading non-relational database in the world. As such, it's the perfect starting place for learning NoSQL operations like indexing, regular expression, data sharding, etc. In the next few blogs, we'll learn how to work with MongoDB using the new Navicat for MongoDB database management & design tool. In today's tutorial, we start with the basics of database and document creation.

In this section we'll connect to our active MongoDB service and add a brand new database.

  • Launch the Navicat for MongoDB application.

  • Click the Connection... button on the main toolbar and select MongoDB... from the list:

  • On the New Connection dialog, enter a name in the Connection Name field:
    You can test the connection by clicking the Test Connection button.
    If you need it, you can also obtain the server URI - i.e. mongodb://localhost:27017/ - by clicking the URI button.

  • Click the OK button to close the dialog and create the connection. It will then appear in the left-hand Connection list.

With our connection in place, we are now ready to create a new database.

  • Double-click the connection in the Connection list to open the database connection.

  • Next, right-click the connection name and choose Create Database... from the context list.

  • A dialog will appear in which you can provide the database name. After you have done so, click the OK button to close the dialog and create the new database.

Behind the scenes, Navicat employs the MongoDB 'use' command to create the database. It will then appear under the current connection in the left-hand Connection list.

Now, we'll add a collection. A Collection is a group of MongoDB documents. It is the equivalent of an DBMS table. A collection exists within a single database. Typically, all documents in a collection are related in purpose or otherwise similar in some way or another.

MongodbMongoDB
  • If you expand the Database object by clicking on the arrow to the left of the DB name, you will see all of the database objects, including its Collections:
    Moreover, clicking on the Database object or any of its objects will enable applicable commands on the Database Objects Toolbar, in particular, the New Collection, Import Wizard, and Export Wizard buttons:
  • Click the New Collection button. That will bring up a new Untitled Collection Tab:
    It contains several child tabs for specifying all of the collection's attributes. We will cover these in a future blog. For now, we'll save it with the defaults.
  • Click the Save button on the Untitled Collection Tab and enter the Collection name in the prompt.

The new collection will be added to the Database Explorer, under the Collections object:

Navicat For MongoDBMongodb

In today's tutorial, we learned the basics of database and document creation in MongoDB using the new Navicat for database management & design tool. So far, the process has been similar than that of traditional DBMSes. In the next blog, we'll be getting into uncharted territory when we add documents to our collection.

Navicat Essentials for Oracle (Windows) - Oracle Visual Query Builder

Navicat Essentials for Oracle is graphical database management and development tools for Oracle. It is a fast, reliable and affordable Database Administration tool purpose-built for simplifying database management and reducing administration costs.

Navicat Essentials for PostgreSQL (Windows) - The best Admin tool

Navicat Essentials for PostgreSQL is compact version of Navicat for PostgreSQL which provides basic and necessary features you will need to perform simple administration on a database. It is a fast, reliable and affordable database tool.

What Is Mongodb Good For

Navicat Essentials for SQL Server (Windows) - SQL Server GUI tool - MS SQL management

Navicat Essentials for SQL Server is an affordable Database Administration tool purpose-built for simplifying database management and reducing administration costs. Navicat is easy-to-use, powerful and supports SSH for remote SQL Server connection.

Navicat Essentials for SQLite (Windows) - SQLite Administrator Tool

Navicat Essentials for SQLite (SQLite Editor - support SQLite version 2 and 3) is a powerful database administration and development tool for SQLite. It is built with an intuitive GUI which lets you manage your database in easy way.

When To Use Mongodb

Navicat Monitor - the best server monitoring tool

Navicat Monitor applies agentless architecture to monitor your MySQL, MariaDB and Percona servers, and collect metrics at regular intervals. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. The repository database can be an existing MySQL, MariaDB, PostgreSQL, or Amazon RDS instance. Navicat Monitor includes a rich set of real-time and historical graphs that allow you to drill down into server statistic details. It gives you a detailed view of each server load and performance regarding its availability, disk usage, network I/O, table locks and more, which allows you to easily track the deviations and traffic among servers, as well as examine possible solutions and adjust your server settings. Our interactive dashboard lists all the monitored instances and allows you to easily see how your instances are currently functioning. It also gives you an overview of the performance, availability and health of each instance.

Coments are closed

Recent News

  • Amazing Audio Player
  • MaCommander
  • KJams

Scroll to top