I added some indexes using SQLite syntax:
db.executesql('CREATE INDEX IF NOT EXISTS me_indx_1 ON meet_event
(id_event);')
But I have to say, the database slowed down so much it actually made
the web pages time out! I have NO idea why declaring some indexes
would cause it to go slower. I removed the indexes with the following
and all was well again:
db.executesql('DROP INDEX IF EXISTS me_indx_1;')
-- Joe B.
P.S. "me_indx" was "meet event index" not the first part of "me
myself and I".
On May 19, 7:57 am, TheDude <[email protected]> wrote:
> Hmm may be we can add an "index=True" option?
>
> Even better have something like:
> db.add_index('table', 'name_index_as', ['field1','field2'],
> unique=True)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
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/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
