Op 9 feb 2014, om 20:50 heeft big stone het volgende geschreven:
Hi,
You're right,' recommands' is not in the code, but was not run anymore
either.
The "x" table cte definition should be removed, as the final
request use
only "q".
Anyway, after all this algorithmic surgery, Postgresql was slower
with the
'optimization' algorithm than with the brute force.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Postgresql is out of competition then:
http://www.sqlite.org/lang_with.html#sudoku runs about 10% slower
there (after s/instr/strpos/).
Bigstone's https://www.mail-archive.com/sqlite-users@sqlite.org/msg81630.html
takes three times longer in Psql.
(psql version 8.4.19)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
