Yup!, i've just created a test case of this behaviour in mysql console, so it has nothing to do with rails.
Anyway thanks for your help! On 7 Mar, 00:02, Philip Hallstrom <[email protected]> wrote: > Based on this, I'd say there is something wrong with your database. > Or at the OS level... swapping, bad disks, something. > > I'd remove rails from the equation and run a test update query > directly via mysql until you can figure it out. > > On Mar 6, 2009, at 2:38 PM, Tomim wrote: > > > > > Tables are almost empty - just a few(<10) records for testing. > > It seems that those slow queries happen sporadically, one time it > > takes 3.4sec, the next time 0.0002sec. > > But the interesting part is that it always takes very short or very > > long amount of time - never in between. > > So because the whole database holds just a few records, and there are > > moments that it works as it should - i think it is a server/caching > > issue. > > I just started developing this app, and it only has primary keys on > > "id" column, no other indexes etc. > > > On 6 Mar, 22:40, Philip Hallstrom <[email protected]> wrote: > >>>>> The problem is that some queries take more than 1sek! - and i've > >>>>> got > >>>>> no idea why. > >>>>> This doesnt happen on my localhost (sqlite/mysql). > > >> Can we see the describe output of those tables? (users, projects, > >> users_projects)? Also, how many rows in each? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
