On 2/16/06, blueranger <[EMAIL PROTECTED]> wrote: > > OK, OK, so I was bored!! > > I sat down in front of my server the other afternoon, browsed these > pages and saw that other people were successfully changing over from > SQLite to MySQL. I already have Microsoft SQL installed on my server, > the same box that I run SlimServer on, so...... "Why not?" I thought! > It would be interesting to compare the performance with SQLite and > MySQL.
I did exactly what you did, and got to the same point. Here's the thread, in case you didn't find it yet: http://forums.slimdevices.com/showthread.php?t=1930 It got down to the way that the ODBC driver was translating insert statements, specifically for identity columns, I think. I tried a couple of workarounds, but if I recall correctly the biggest problem was that the SQL used to do work on the database isn't abstracted out per platform, it's inline with the rest of the code. I suspect that someone would need to do work on the perl code to separate out access the data layer, but it's beyond me (if it was Delphi / dotnet, I'd happily have a crack - I just don't have time to learn perl at the moment). Cheers Geoff _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
