New Message: Scaling Manila with mySQL

[webmaster at userland.com]

A new message was posted:

Address: http://manila.userland.com/discuss/msgReader$460

By: Steve Hooker (steve at cybersaps.com)

Following the post about too many messages in one manilawebsite I'm trying to migrate the discussion group over to mySQL. Using Mr Tallent's ODBC extension, I'm able to whack the whole of, what is today 143,439 messages, into a mySQL database. So far so cool ;-)

However, now I need to *get at this stuff* with Manila!

Before I start to re-write loads of Manila and mainResponder code, I thought it wise to ask if anyone has been here before, if there are any shortcuts, writing and getting discussion group messages that are stored in a SQL db? By pointing to a different discussion group address for example, which may contain scripts to get at theSQL stuff?

Any advice, tips, suggestions very welcome!

Steve Hooker

http://www.cybersaps.org/