Re: [sqlite] EXT :Re: SELECT query first run is VERY slow

2011-07-25 Thread Григорий Григоренко
> > Michael D. Black > > Senior Scientist > > NG Information Systems > > Advanced Analytics Directorate > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Григорий Григоренко [grigor

Re: [sqlite] EXT :Re: SELECT query first run is VERY slow

2011-07-25 Thread Black, Michael (IS)
Григоренко [grigore...@mail.ru] Sent: Monday, July 25, 2011 3:30 AM To: sqlite-users Subject: EXT :Re: [sqlite]SELECT query first run is VERY slow Okay, here are some steps I've done. 1) normalize db; I've created single table (item). "computer","process" and "who" f