Hi,
While I am open to looking at ways of removing the MSVCR90.DLL (and
also recompiling using sqlite 3.6.9), I **suspect** at the same time
that more people are interested in multi-lingual support than
performance? What I mean is, if people really want performance then, I
would imagine, they would be looking at a custom build of sqlite? Then
again, perhaps it's the other way round - there is also the question
of how do we go about keeping this up to date...
In the process of doing all this work, I also compiled, separately, an
sqlite extension called sqliteicu.dll which one should be able to load
as follows:
.load './sqliteicu.dll'
select upper('Τρία πουλάκια κάθονταν και πλέκανε πουλόβερ..');
I haven't had the chance to test this. In fact, I don't know how to
load an sqlite extension from Python and web2py. However, an optional
extension, compiled without the MSVCR90.DLL dependency might be the
best way to deal with this since its the best of both worlds, an
officially maintained sqlite3.dll and an optional extension - if it
works that is!
On Jan 14, 9:16 am, "Markus Gritsch" <m.grit...@gmail.com> wrote:
> Hi again,
>
> also note, that the unicode-aware LIKE operator does not come for
> free. A simple
>
> SELECT * FROM entry WHERE note LIKE '%test%'
>
> on a moderately large DB of about 100 MB of data is more than three
> times slower using the ICU extension than without it.
>
> 1.14 sec with sqlite3.dll which ships with Python 2.5
> 3.52 sec with your compiled sqlite3.dll and the icu*.dlls
>
> One should take this (and the currently different MSVCR DLLs) into
> account before including it into the official Windows binary
> distribution of web2py. I think it depends on the situation if it is
> worth the benefit of an unicode aware LIKE operator.
>
> Kind regards,
> Markus
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
