CLEAR GRAPH Statement Very Slow Performance
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version 126.96.36.199 and later
Information in this document applies to any platform.
Using Oracle Semantics and inserting millions of statements in the database, all in the same graph, via SPARQL Update through Joseki. Attempted to empty the graph by running the SPARQL Update statement CLEAR GRAPH against the database. This runs for at least 16 hours without finishing.
The exact statement issued is "CLEAR GRAPH ".
All interaction with the database has so far been through Joseki and the Jena Adapter API.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms