Sure. I'm using BaseX 8.2.3 on linux, using the C# client located at
https://github.com/BaseXdb/basex/blob/master/basex-api/src/main/c%23/BaseXClient.cs.
The DB, as reported by the rest interface:
<rest:database resources="1015172" size="10063643321">mferrari_test_6</rest:database>
This is my simplified test function:
static void DoSingleDeleteProcessing(string db)
{
int localId = 310072;
BaseXClient.Session baseXClientSession = new BaseXClient.Session(server, 1984, user, password);
baseXClientSession.Execute("open " + db);
string filename = "prueba" + localId.ToString("D8") + ".xml";
baseXClientSession.Execute("DELETE " + filename);
baseXClientSession.Close();
}
This is what I get in the logs:
17:20:22.253 10.1.5.144:61340 admin REQUEST OPEN mferrari_test_6 39.83 ms
17:20:22.321 10.1.5.144:61340 admin OK Database 'mferrari_test_6' was opened in 68.44 ms. 68.54 ms
17:20:22.324 10.1.5.144:61340 admin REQUEST DELETE prueba00310072.xml 1.47 ms
17:21:20.794 10.1.5.144:61340 admin OK 1 resource(s) deleted in 58469.92 ms. 58469.98 ms
A Replace on the same DB results in the following entries:
17:24:38.070 10.1.5.144:61359 admin REQUEST OPEN mferrari_test_6 39.97 ms
17:24:38.138 10.1.5.144:61359 admin OK Database 'mferrari_test_6' was opened in 67.69 ms. 67.79 ms
17:24:38.170 10.1.5.144:61359 admin REQUEST REPLACE prueba00310071.xml [...] 0.34 ms
17:24:38.548 10.1.5.144:61359 admin OK 0 resource(s) replaced in 377.84 ms. 377.98 ms
Thanks!
Martín.
> Subject: Re: [basex-talk] DELETE Performance
> From: alex@holupirek.de
> Date: Tue, 25 Aug 2015 09:06:59 +0200
> CC: basex-talk@mailman.uni-konstanz.de
> To: ferrari_martin@hotmail.com
>
> Hi Martín,
>
> could you provide a simple, self-contained code snippet that demonstrates this behaviour? This way we could have a look.
>
> Alex
>
> > On 25.08.2015, at 00:43, Martín Ferrari <ferrari_martin@hotmail.com> wrote:
> >
> > Hi:
> > I have a DB with around a million records. Adding resources to it takes some milliseconds. However, executing DELETE on a resource takes more than 60 seconds. Am I doing something wrong? Is this by design?
> >
> > Thanks!
> > Martín.
>