Re: sqlite question
Re: sqlite question
- Subject: Re: sqlite question
- From: Axel Luttgens <email@hidden>
- Date: Mon, 20 Apr 2015 10:31:05 +0200
> Le 19 avr. 2015 à 23:23, Axel Luttgens a écrit :
>
>
>> Le 19 avr. 2015 à 19:20, Jim Weisbin a écrit :
>>
>> […]
>> local:
>> real 0m0.044s
>> user 0m0.013s
>> sys 0m0.015s
>>
>> remote:
>> real 0m29.478s
>> user 0m0.051s
>> sys 0m0.123s
>> […]
>
> Ouch!
> I’ll try to perform some trials tomorrow.
> And thanks for the other details.
So, this is what I get here:
File server: Mac OS X 10.8.4 (12E55), afpserver-607.2
Database "jim": one table with two columns, 14001 rows.
$ sqlite3 --version
3.8.5 2014-08-15 22:37:57 c8ade949d4a2eb3bba4702a4a0e17b405e9b6ace
$ time sqlite3 Desktop/jim_db/jim 'SELECT * FROM player_view' >/dev/null
real 0m0.016s
user 0m0.011s
sys 0m0.003s
$ time sqlite3 /Volumes/SharePoint/luttgens/jim_db/jim 'SELECT * FROM player_view' >/dev/null
real 0m0.102s
user 0m0.018s
sys 0m0.012s
I’ll send you (privately) a zipped copy of database file "jim"; could you perform the same tests on that one?
Axel
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden