You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by yangjiajun <13...@qq.com> on 2018/11/29 13:36:16 UTC

Is there any way to speed up delete data or drop table?

Hello.

We need to fully sync data from mysql to ignite periodicity.Thus we need to
clear data in ignite first.Ignite does not support truncate statement and
its drop table statement sometimes takes long time.It's also very slow to
delete all data in ignite's tables or caches.Is there any way to speed up
delete data or drop table?Or is there some methods like truncate?



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Is there any way to speed up delete data or drop table?

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

Maybe dropping a cache will be somewhat faster when this cache is a part of
existing cache group:
https://apacheignite.readme.io/docs/cache-groups

Regards,
-- 
Ilya Kasnacheev


чт, 29 нояб. 2018 г. в 16:44, yangjiajun <13...@qq.com>:

> Hello.
>
> We need to fully sync data from mysql to ignite periodicity.Thus we need to
> clear data in ignite first.Ignite does not support truncate statement and
> its drop table statement sometimes takes long time.It's also very slow to
> delete all data in ignite's tables or caches.Is there any way to speed up
> delete data or drop table?Or is there some methods like truncate?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>