Performance Questions
1. If TcaplusDB is deployed on a mainstream machine, how many seconds does it take to create or delete a table?
Under normal circumstances, the table operation is at the second level.
2. Is there a big difference in efficiency between batch addition and single addition in python? Is there only one transaction for the former and a table creation transaction for each table for the latter?
The efficiency is similar. Tcapcenter also processes the addition of a table as a transaction. Batch addition is a batch operation that reduces the number of submissions. However, one table addition transaction is executed for each table in tcapcenter.
3. Does TcaplusDB support pulling hundreds of thousands of data in full? The data volume is about 5 to 20 M, and the interface is not commonly used
Table traversal is supported
4. How long will it take to add some parameters to a table in the pb table?
Table change can be completed in seconds. And the table can be changed online without stopping the service.