Re: #1024, it looks like MySQL does allow indices on TEXT fields, so long as you explicitly specify a key length.
The SQLite docs (http://www.sqlite.org/lang_createindex.html) mention something about creating a collation for TEXT fields, but I don't understand the various options on that yet. --Blake On Aug 2, 6:15 am, "Michael C. Harris" <[email protected]> wrote: > Forgive me, Father, for it has been 35-odd days since the last > edition. Some bastard burgled my laptop ... Unfortunately, only one of > the tickets I covered last time[1] has been closed, so feel free to go > back and have a look at them. > > Since the last edition: 26 commits, 20 new tickets and 11 closed tickets > > Let's look at some highlights. > > #1029 CURLRequestProcessor::execute() fails to work with PHP 5.2.10 > This one is the most fun because, due to a cURL bug introduced in PHP, > no-one can install Habari on PHP 5.2.10 or 5.3. The bug is fixed in > PHP trunk, but we're still going to have to deal with it urgently. > There's a patch that basically rolls back r3061, which was introduced > to reduce memory usage, but it would be great if we could find a > better way. > > #1024 Improve performance of post selection based on info record content > Searching for posts based on info records is currently very slow, but > this is likely to be a common use case for custom content types. Can > we simply add an index to postinfo.value ? > > #1022Installer should be web server and database agnostic > There is currently a lot of Apache-specific code (like .htaccess > stuff) in the installer. It would be great if we could abstract that > out, which would make it easier to maintain support for different > servers. > > #1016 Restoring A Post Succeeds But With Warnings > I haven't tried to reproduce this yet, but it seems there might be an > error in the Undelete plugin in core. > > Discuss (here or on the ticket), fix, close, as appropriate. > > [1]http://pastoid.com/bv3+ > > Ticketshttp://trac.habariproject.org/habari/ticket/1029http://trac.habariproject.org/habari/ticket/1024http://trac.habariproject.org/habari/ticket/1022http://trac.habariproject.org/habari/ticket/1016 > > -- > Michael C. Harris, School of CS&IT, RMIT > Universityhttp://twofishcreative.com/michael/blog > IRC: michaeltwofish #habari --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
