DELETION of data in 10M items

nebula-contrib / ngbatis

NGBATIS is a database ORM framework base NebulaGraph + spring-boot, which takes advantage of the mybatis’ fashion development, including some de-factor operations in single table and vertex-edge, like mybatis-plus. NGBATIS 是一款针对 NebulaGraph + Springboot 的数据库 ORM 框架。借鉴于 MyBatis 的使用习惯进行开发。https://graph-cn.github.io/ngbatis-docs/

https://nebula-contrib.github.io/ngbatis/

Apache License 2.0

132 stars 42 forks source link

DELETION of data in 10M items #171

Open zhangxk-ocean opened 1 year ago

zhangxk-ocean commented 1 year ago

删除上千万条数据，有什么效率高的好方法没，现在4000w条，删3000w条数据，留1000w条数据，id是顺序生成的，把id在1000万到4000万的数据都删了

CorvusYe commented 1 year ago

试试 nGQL 的管道符？

zhangxk-ocean commented 1 year ago

这个也行，我们用的最简单方法，删图空间，重新建一个，再导入数据