"Rosemary Alles" <al...@ipac.caltech.edu> wrote in message news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu > Run on a single processor, the following query is quite fast: > > When concurrency is introduced (simply running the query on several > processors against the same database - say 300 instances of it) causes > a massive slow down
Well, you may have multiple CPUs, but you only have a single hard drive. That drive head can't be in multiple places simultaneously. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users