[CDBI] Make CDBI go fast
list at bereft.net
Thu Mar 22 00:27:35 GMT 2007
Michael G Schwern wrote:
> Brad Bowman wrote:
>> Does any database allow a LIMIT $N index? I mean, maintaining an index
>> of the top 10 only, updating as the appropriate. Or is this best done
>> another way?
>> Sounds like my suggestion wouldn't apply in any case, given the flexibility
>> of the searches.
> Postgres might be able to do it, given its general flexibility. It allows you
> to index expressions and using WHERE clauses already. Unfortunately only
> indexing the first N doesn't help as soon as someone asks for the next N.
> Still, it might help if most folks don't ask for the next page.
Don't you just love Postgres:
Mysql, "You cannot associate a trigger with a TEMPORARY table or a view."
Furthermore, if you are slain in battle, you should be resolved to
have your corpse facing the enemy. -- Hagakure
More information about the ClassDBI