[Pan-users] Re: "MySQL Backend?"

[Duncan]

SciFi <address@hidden> posted
address@hidden, 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