Re: [fossil-users] Accelerate multi-repository queries

2017-05-26 Thread Florian Balmer
Zakero: > Did you check the execution time of the "find | sort" versus the > "listfossil()"? Looking at your script, I think you can simplify it > a bit. The script takes between 1.2 and 1.8 seconds in the original form, and between 130 and 160 ms if the `listfossil()' function is simplified to

Re: [fossil-users] Accelerate multi-repository queries

2017-05-26 Thread Zakero
Hello Florian, Did you check the execution time of the "find | sort" versus the "listfossil()"? Looking at your script, I think you can simplify it a bit. # Pass all Repositories and output their name and description fossil_info() { for REPO in $@ do echo $(basename "$REPO") fossil

Re: [fossil-users] Accelerate multi-repository queries

2017-05-26 Thread Florian Balmer
On another server, where I have access to PHP, it also takes less than 100 ms to query the repository files using the built-in PDO/sqlite interface. So it seems that running ./sqlite3 instead of ./fossil could speed up the queries. --Florian ___

Re: [fossil-users] Accelerate multi-repository queries

2017-05-26 Thread Richard Hipp
On 5/26/17, Florian Balmer wrote: > > For 10-20 repositories, the following (skeleton) shell script takes > more than 1 second to finish: > > #!/bin/sh > ... > listfossil() { > echo "$(basename "$1")" > cat <<'SQL' | ./fossil sql --repository "$1" > SELECT value