imageboards

Hey ^EXPERT _PROGRAMMERS
I want to make something that'll archive the imageboards I want. I know the text field is limited to 2000 characters, but what about the name/mail/subject ones? Oh, and how does it work with unicode characters?

>>17
This operation is O(1) for databases. If you're going to use table from >>13, here is request to get thread that is confirmed to work fast:
select * from $self->{table} where num=? or parent=?
and here's page:
select * from
    (select num from $self->{table} where parent=0 order by num desc limit ? offset ?) as threads join $self->{table}
        on threads.num=$self->{table}.num or threads.num=$self->{table}.parent
            order by case parent when 0 then $self->{table}.num else parent end asc,timestamp asc

This is mostly taken from wakaba