My application starts the basex server (and only stops the server when the application closes) and attempts to open the database that it expects to find. If it doesn’t find it, it will create it with the source XML files. When a user wants to update the database, it simply drops it and recreates it from the XML files…actually executing the exact same code. I see that the database creation time for those two tasks is quite different. The first one takes quite a bit longer.

If, when the application starts, it DOES find the database, it opens it. If the user then clicks “update” it does the drop/recreate process. If it does it again, it does the drop/recreate process. It seems that in these cases, the first one also takes noticeably longer. Subsequent updates are faster.

My conclusion is that the first CREATE DB after starting the server takes longer than all the subsequent ones before the server is stopped. Is this a “memory acquisition” issue? I.e. the server starts with a small memory footprint by default and then simply asks (frequently) for more when it needs it? If so, can it be started with a larger amount initially or tell it to grab it in larger quantities in order to reduce the time for the initial database creation? If that has nothing to do with it, any other ideas?

Here is my basex log illustrating these two examples:

18:19:15.419 Server was started.

18:19:15.905 [127.0.0.1:60244] LOGIN admin OK

18:19:16.032 [127.0.0.1:60244] OPEN OpenSongSearch Error: Database 'OpenSongSearch' was not found. 32.63 ms

18:19:16.049 [127.0.0.1:60244] LOGOUT admin OK

18:19:16.469 [127.0.0.1:60245] LOGIN admin OK

18:19:16.493 [127.0.0.1:60245] DROP DB OpenSongSearch OK 0.77 ms

18:19:16.493 [127.0.0.1:60245] SET CREATEFILTER * OK 0.66 ms

18:19:16.494 [127.0.0.1:60245] SET ENTITY true OK 0.42 ms

18:19:16.494 [127.0.0.1:60245] SET FTINDEX true OK 0.36 ms

18:19:16.495 [127.0.0.1:60245] SET INTPARSE true OK 0.36 ms

18:19:16.495 [127.0.0.1:60245] SET PARSER xml OK 0.32 ms

18:19:16.496 [127.0.0.1:60245] SET WILDCARDS true OK 0.34 ms

18:20:31.458 [127.0.0.1:60245] CREATE DB OpenSongSearch C:\Users\David\DOCUME~1\OpenSong\Songs OK 74961.71 ms

18:20:31.460 [127.0.0.1:60245] LOGOUT admin OK

18:20:33.146 [127.0.0.1:60262] LOGIN admin OK

18:20:33.175 [127.0.0.1:60262] OPEN OpenSongSearch OK 9.2 ms

18:20:33.177 [127.0.0.1:60262] INFO DB OK 1.66 ms

18:20:33.177 [127.0.0.1:60262] CLOSE OK 0.38 ms

18:20:33.178 [127.0.0.1:60262] LOGOUT admin OK

18:21:10.314 [127.0.0.1:60270] LOGIN admin OK

18:21:10.340 [127.0.0.1:60270] DROP DB OpenSongSearch OK 7.85 ms

18:21:10.340 [127.0.0.1:60270] SET CREATEFILTER * OK 0.25 ms

18:21:10.341 [127.0.0.1:60270] SET ENTITY true OK 0.29 ms

18:21:10.341 [127.0.0.1:60270] SET FTINDEX true OK 0.23 ms

18:21:10.341 [127.0.0.1:60270] SET INTPARSE true OK 0.23 ms

18:21:10.342 [127.0.0.1:60270] SET PARSER xml OK 0.25 ms

18:21:10.342 [127.0.0.1:60270] SET WILDCARDS true OK 0.25 ms

18:21:17.190 [127.0.0.1:60270] CREATE DB OpenSongSearch C:\Users\David\DOCUME~1\OpenSong\Songs OK 6848.68 ms

18:21:17.195 [127.0.0.1:60270] LOGOUT admin OK

18:21:18.140 [127.0.0.1:60272] LOGIN admin OK

18:21:18.167 [127.0.0.1:60272] OPEN OpenSongSearch OK 9.26 ms

18:21:18.168 [127.0.0.1:60272] INFO DB OK 1.05 ms

18:21:18.169 [127.0.0.1:60272] CLOSE OK 0.36 ms

18:21:18.169 [127.0.0.1:60272] LOGOUT admin OK

18:21:20.636 Server was stopped.

19:11:23.757 Server was started.

19:11:24.319 [127.0.0.1:61004] LOGIN admin OK

19:11:24.899 [127.0.0.1:61004] OPEN OpenSongSearch OK 517.02 ms

19:11:24.903 [127.0.0.1:61004] INFO DB OK 3.75 ms

19:11:24.905 [127.0.0.1:61004] CLOSE OK 2.23 ms

19:11:24.906 [127.0.0.1:61004] LOGOUT admin OK

19:11:25.358 [127.0.0.1:61005] LOGIN admin OK

19:11:25.724 [127.0.0.1:61005] OPEN OpenSongSearch OK 348.05 ms

19:11:25.727 [127.0.0.1:61005] INFO DB OK 2.81 ms

19:11:25.728 [127.0.0.1:61005] CLOSE OK 0.88 ms

19:11:25.729 [127.0.0.1:61005] LOGOUT admin OK

19:11:49.961 [127.0.0.1:61013] LOGIN admin OK

19:11:49.985 [127.0.0.1:61013] DROP DB OpenSongSearch OK 6.82 ms

19:11:49.986 [127.0.0.1:61013] SET CREATEFILTER * OK 0.67 ms

19:11:49.986 [127.0.0.1:61013] SET ENTITY true OK 0.32 ms

19:11:49.987 [127.0.0.1:61013] SET FTINDEX true OK 0.37 ms

19:11:49.987 [127.0.0.1:61013] SET INTPARSE true OK 0.34 ms

19:11:49.988 [127.0.0.1:61013] SET PARSER xml OK 0.4 ms

19:11:49.988 [127.0.0.1:61013] SET WILDCARDS true OK 0.34 ms

19:12:09.591 [127.0.0.1:61013] CREATE DB OpenSongSearch C:\Users\David\DOCUME~1\OpenSong\Songs OK 19602.28 ms

19:12:09.592 [127.0.0.1:61013] LOGOUT admin OK

19:12:10.547 [127.0.0.1:61018] LOGIN admin OK

19:12:10.598 [127.0.0.1:61018] OPEN OpenSongSearch OK 8.42 ms

19:12:10.599 [127.0.0.1:61018] INFO DB OK 0.96 ms

19:12:10.600 [127.0.0.1:61018] CLOSE OK 0.39 ms

19:12:10.601 [127.0.0.1:61018] LOGOUT admin OK

19:12:20.716 [127.0.0.1:61021] LOGIN admin OK

19:12:20.742 [127.0.0.1:61021] DROP DB OpenSongSearch OK 8.13 ms

19:12:20.742 [127.0.0.1:61021] SET CREATEFILTER * OK 0.27 ms

19:12:20.743 [127.0.0.1:61021] SET ENTITY true OK 0.26 ms

19:12:20.743 [127.0.0.1:61021] SET FTINDEX true OK 0.25 ms

19:12:20.744 [127.0.0.1:61021] SET INTPARSE true OK 0.27 ms

19:12:20.744 [127.0.0.1:61021] SET PARSER xml OK 0.25 ms

19:12:20.745 [127.0.0.1:61021] SET WILDCARDS true OK 0.26 ms

19:12:26.555 [127.0.0.1:61021] CREATE DB OpenSongSearch C:\Users\David\DOCUME~1\OpenSong\Songs OK 5811.0 ms

19:12:26.557 [127.0.0.1:61021] LOGOUT admin OK

19:12:27.677 [127.0.0.1:61024] LOGIN admin OK

19:12:27.705 [127.0.0.1:61024] OPEN OpenSongSearch OK 7.94 ms

19:12:27.706 [127.0.0.1:61024] INFO DB OK 0.99 ms

19:12:27.707 [127.0.0.1:61024] CLOSE OK 0.37 ms

19:12:27.707 [127.0.0.1:61024] LOGOUT admin OK

19:12:29.820 Server was stopped.

Thanks!