On Thu, 17 Feb 2011 07:30:47 -0500, Richard Hipp <d...@sqlite.org> wrote:
> Using threads is like running with scissors - You are likely to get hurt > and so the best approach is to not do it. > > If you want to run queries in parallel, I suggest putting each query in a > separate process. > > If your knowledge of threads is so limited that you don't know how to > enable them and you are trying to use pthreads on windows, then your > chances of getting hurt are compounded. This is all the more reason to > use separate processes, not threads, for parallelism. FYI, Windows NT is documented to have light threads and heavy processes. To my knowledge, it just was not designed with the goal of *nix/Plan 9/et al.’s more-or-less cheap and easy fork()/exec(). Of course, since the original poster was using pthreads, he probably doesn’t care. (There exists a popular pthreads/win32 package; it is reputed slow, I cannot attest either way as thereto, and it may or may not be what the original poster was using.) Very truly, Samuel Adam ◊ <http://certifound.com/> 763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States Legal advice from a non-lawyer: “If you are sued, don’t do what the Supreme Court of New Jersey, its agents, and its officers did.” http://www.youtube.com/watch?v=iT2hEwBfU1g _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
