From: Dave Lilley Date: 2009-06-08T20:28:13+09:00 Subject: sqlite3 & joins this question goes on from my previous one about my 1st hurdle using SQLite3. what sort of performance hit will you get if you have 3 select statements (1 for each table/DB file)? tables are customer, Jobs, parts. customer has a unique field called customer number. Jobs has a field for the customer number in it and a unique field called Job number. lastly parts has a field called job number. not sure how many rows there might be for a customer and rows for parts at present. but really I'm more concerned with getting everything playing in tune and then when I'm more familiar wit SQLite look at optimizations like using joins. an yes ultimately i may move off sqlite to another DB but that's another step. Oh also all this is via DBI. Active record will be another stepping stone (Feel like I've got too much to cope with for now but perhaps ultimatly go to active record too). cheers, dave. -- Posted via http://www.ruby-forum.com/.