Panorama does not seem to support SQL (I did not find the term SQL on its feature-page http://www.provue.com/panorama5.html), it requires a paid runtime-version for distribution, it is restricted only for Mac and Windows. It seems to need a lot of RAM, because it seems to mirror its database into RAM, that is the way how it come to speed, also disadvantage that for transactions to work safe, data have to be written to disk in between, this should be taken into benchmarks
see http://www.provue.com/ Bert > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > rg] On Behalf Of Richard > Sent: 06 October 2005 04:57 > To: SQLite Users Mailing List > Subject: [sqlite] Speed Test Done ! > Importance: High > > Well, finally import 9,337,681 records into sqlite3 test2.db > and ran the test. > > > import sqtest4.txt : 2 min 28 seconds > select A, '32.0833' From T ; 9 min 20 seconds > -- > > > I use another database for MacOS X > also works on Windows, Call Panorama > > Did another test, comparing database... > > import sqtest4.txt : 36 seconds > select from Field A contains 32.0833 / 55 seconds found 4322 records > out of 9,337,681 > > Still have found no sql program yet, that can beat Panorama in speed. > > Regards- > Richard Nagle > CMS -- Met vriendelijke groet Bert Verhees ROSA Software
