On 2/1/07, Matthew Gillen <[EMAIL PROTECTED]> wrote: > > ... snip ...
> You could see if sqlite is slow for whatever reason using it's command line > client: > -------------------- > $ sqlite3 /path/to/trac.db > SQLite version 3.3.6 > Enter ".help" for instructions > sqlite> select * from ticket where id=1; > -------------------- > Thanks for the tip ... I've tried that and the response is very fast ... I couldn't measure it, but even a "select * from ticket" gets dumped instantaneously. > If that command takes a long time to return (try for a few different values of > 'id'), then you have your culprit, and you may want to accelerate the > scheduled move to PostGRESQL... > The move to PostreSQL will be done, nevertheless ... Specially because I want to try out the 'shared database for each environment' that will allow me to have a single definition for entities like priority, severity ... > Other than that, I can't think of what could be hanging it up. Thank you again, I will keep trying ... when I have a definitive answer, will post the cause of the problem here ... > > Good luck, > Matt Kind regards, Leandro. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" 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/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
