Forum OpenACS Development: Response to Query optimization

Collapse
7: Response to Query optimization (response to 1)
Posted by Don Baccus on 03/06/02 04:38 AM
What happens if you do declare an index on user_id, even though the table's volatile?  It will slow inserts and updates but should make selects go much faster.

Anyway, I'm glad that exists is fast when you've tested with an index!