On Tue, Mar 08, 2016 at 09:59:18AM +1100, Chris Sherlock wrote: > I understand, but the situation with Firebird seems less than ideal, > at least in terms of Windows builds at any rate.
> Are the tests really that much slower? Obviously we are relying on > having a Java installation to test out Base. The performance issues were not limited to tests, but also to actual usage by humans. There were quite some complaints about performance, user-noticeable and user-annoying, when on GNU/Linux, starting with Java version XXX, things got slower. (There were also other performance issues.) Various hacks to work around that were discussed, but never really implemented. > > On 8 Mar 2016, at 2:11 AM, Lionel Elie Mamane <lio...@mamane.lu> wrote: > > > > On Tue, Mar 08, 2016 at 02:06:07AM +1100, Chris Sherlock wrote: > >> Is HSQLDB out of the question? > > > > HSQLDB2 and H2 are good choices if we decide to stay with a Java-based > > one (which brings performance problems because of the slowness of > > crossing the C++-to-Java barrier). > > > >>> On 7 Mar 2016, at 11:32 PM, Noel Grandin <noelgran...@gmail.com> wrote: > >>> > >>> > >>> > >>>> On 2016/03/07 2:11 PM, Lionel Elie Mamane wrote: > >>>> On Mon, Mar 07, 2016 at 08:23:53AM +0200, Noel Grandin wrote: > >>>> A few examples of how SQLite differs from the SQL standard (be it de > >>>> facto > >>>> or de jure standard) in quite deep, fundamental ways: > >>>> > >>>> * lack of other datatypes than "integer", "real" (float), "string of > >>>> characaters" > >>>> and "string of bytes": the basic ones are dates, times, timestamps. > >>>> > >>>> * lack of datatype checking; one can insert "noel" in a column of > >>>> type "integer" > >>>> > >>>> * type attached to value, not to column > >>> > >>> > >>> That is true, but we could implement basic checking of our own on top of > >>> that, or just ignore it, and rely on the user getting it right most of > >>> the time (which they normally do). And when they don't, it is a rather > >>> soft failure mode in SQLite. > >>> > >>> > >>>> > >>>> Also annoying, but can be worked around: > >>> > >>> Yeah, that's what I mean - there are other issues, but they can be worked > >>> around. > >>> > >>> I suppose we can just keep limping along with our current state of > >>> affairs, it's not like Base is that widely used, or particularly vital to > >>> our future. > >>> > >>> But it would be nice to upgrade to something a little more modern, and > >>> Firebird is not really working out for us, and what other options do we > >>> really have? > >>> > >>> At least SQLite is widely used and moving forward at a reasonable rate. > >>> > >>> Regards, Noel. > >>> > >>> _______________________________________________ > >>> LibreOffice mailing list > >>> LibreOffice@lists.freedesktop.org > >>> https://lists.freedesktop.org/mailman/listinfo/libreoffice > >> > > _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice
