Hi Sly, Can't really help without the query that you are using and more information about the database. Are you using indexes? How many records are in the tables?
Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -----Original Message----- From: Sylvain Lafleur [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 1:05 PM To: [email protected] Subject: [sqlite] Windows SQLITE3 SUPER SLOW Hello, Sorry if this isn't correct, it's my first post in a mailing list. My problem: I created a Ruby on Rails application with sqlite as the database. Everything worked for about a day. Now, any query with a inner join takes forever (i have yet to actually have results returned). When i pop the query in the sqlite2.exe, same problem, it's like there is an infinite loop. However, when i use the program "SQLITE Browser 1,2.1.exe", the same query returns results instantly. Does anyone have any clue what is going on here. I hope i can fix it and still use sqlite. Thanks Sly
