Enhanced Database Connection (Australian Database Server)

[ayergo]

Noticed the DB search feature up, very nice!

I do like Indio's idea above of using caching. I think we could see some real performance increases, especially for distant servers. We would run the risk of losing data, but i think that if we set it up in a regular interval there wouldn't be a chance of losing much at any time.

Is it possible to cache the data in a local DB, then update the central DB every 24 hours or so?

It might really reduce lag.

[ayergo]

Actually no, the better way to do this would be to do the caching within NWN itself. Have a check in the script every so often to see if anyone is on or 24 hours has elapsed, then write to the central DB.

It should damn near eliminate the lag people experience without any extra bells and whistles.