SciFi <[EMAIL PROTECTED]> posted [EMAIL PROTECTED], excerpted below, on Sat, 12 May 2007 00:20:17 +0000:
> On Fri, 11 May 2007 23:30:42 +0200, Robert Krig wrote: >> >> Hi guys. I was just wondering about something. Would it bring any speed >> improvement if PAN would use a MySQL backend to store Articles and >> Newsgroups? >> >> It seems as if PAN often chokes on very large newsgroups while >> browsing, entering, or updating them. I was wondering if this could be >> improved upon with an (optional) mysql backend as DB Storage? > > I'm quite sure mysqlite is what Unison uses (native OSX news-reader) > <http://www.panic.com/unison/>. Shareware, no open source. And no, it's > not any faster, suffers from same problems in large groups. :( I have > reported it, tho, but it seems to have stumped them as well, no new > update since early February 2007. As both Jim and SciFi mention, the choice would likely be SQLite, and that was the original plan for handling fully automated multi-server as pan now has. (SQLite is MySQL compatible I believe, so those that wished to could then use the full MySQL to access the same database if they desired.) I'm not exactly sure why Charles decided /not/ to go that route with the rewrite, except that he does try to keep external dependencies down, and as SciFi mentions here, no matter what is used, there /will/ be speed issues to be dealt with when header counts get into the multi-millions. -- Duncan - List replies preferred. No HTML msgs. "Every nonfree program has a lord, a master -- and if you use the program, he is your master." Richard Stallman _______________________________________________ Pan-users mailing list Pan-users@nongnu.org http://lists.nongnu.org/mailman/listinfo/pan-users
