How to register a large number of users and crash their database

Because the brand machine is also an assembly machine, the modern popular brand machine is rarely developed and produced by itself, but also after the research and development configuration of professionals, and then choose the hardware of other manufacturers to assemble, the advantage of the brand machine is that the after-sales service is relatively perfect, the hardware compatibility is good, and it is relatively transparent. The disadvantage is that the configuration is relatively fixed, and it is relatively high.

It depends on what kind of database you are.,sqlserver,oracle like this.,It's just a release that lets you register one a second.,You didn't use this method to crash it.。

This is illegal, I hope the little master won't do it.

It's hard to let the database crash no matter how big it is, and he can bear it.

Solution: Find a SQL Server 2005 attached database, export the structure and data of the table, and then import it to SQL Server 2000 In addition, this error occurs when Microsoft SQL Server cannot find the rows corresponding to the required table or index in the Sysindexes table (for example, when executing a stored procedure that references a table that has been removed). If the error occurs because the stored procedure references a table that has already been removed, the stored procedure is removed and recreated.

This error can also occur along with other error messages that better point to the root cause of the problem. execute dbcc checktable on sysindexes; Execute dbcc checkdb as well.

Major Software Releases:

Major Software Fix Releases:

Minor software: n a

Answer: Max database crashes are very rare, but this problem may occur when the system is shut down or restarted due to a sudden power failure or crash. One of the symptoms that can occur when a database crash is clicked on the "" button next to any of the clips in MAX and the folder disappears.

If this phenomenon occurs after installing a new version of MAX, you need to make sure that you have restarted your PC after installing it.

Max backs up the database files, which can be used to recover from database crashes. Here's how to do it: Log in as an administrator or as a user with administrator privileges (if you have firmware installed like f-secure, make sure it remains turned off in the following procedure!).

Quit all NI applications.

Record the registration script and parameterize the registration information by using the LR simulation request.

1. Record the script of the system registration module and debug it.

2. Parameterize the registration information.

The above is ok.

To what extent?

What do you think?

Someone is attacking your database, and it is best to keep the database on the intranet and not open it to the extranet.

The solution: defeat.

1.You can change the port number of the database.

2.If the sa is not used, you can disable and then create an account with the same permissions as the sa.

3.External IP addresses can be masked.

However, these changes need to be evaluated and should not have an impact on the application.

SQL Server database recovery must be preceded by backups, including database backup and log backup (actual processing operations), when the SQL Server database crashes or fails, it can be restored in a timely and convenient manner, menu operations (select "Database" and click "Recover" in the drop-down menu) or command statement operations.

Update and modify directly, there is no need to do any special operations, just to avoid deadlocks, and other people don't come in to query when modifying.

Generally, the amount of large data should not be modified directly, it is best to segment, you can write a loop, about 5k or 5w at a time, otherwise once you encounter a problem, you will roll back all the data, which is time-consuming and resource-consuming.

You can use the Use Collections with Batch processing methods.

Is it Oracle?

It's bulk collect into and forall, use it yourself.

This situation is basically dependent on the backup of the database. If you are attacked, the data is likely to be destroyed, and it is difficult to recover this situation through data recovery.

You can do it yourself quickly, i.e. it will be restored in a few hours.