Please help to make MU Manage Comments Plugin work with Shar DB

SharDB is a new one one me. The plugin does a union on the multisite comments tables. This joins all the comments into one select clause, letting the database do all the work.

Unless shardb is non-standard, I can’t see why it wouldn’t work.

It will crap out if there are too many mu sites so it times out and displays an incomplete page. That may be whats happening to you.

I’ll see if I can find any more info on your db and see if a simple sql fix will make it work.

Keith

@keith the dbs total size on BlogLines.co.za is about 70Gb

@keith if you would like to use my server as a testing ground let me know or just drop me a mail [email protected]

@keith was testing ??

PHP
memory_limit 5024M
max_input_time 3150
max_execution_time 3140

No Luck to get it to work on BlogLines.co.za ??

70 gigs is a huge amount of data. The comments tables are quite a bit smaller than that, but it might or might not work. I am trying to set up a test blog with sharDB to see what is happening.

I might make a debug version of the plugin to show what is going on. I will contact you when I get a chance.

I am working on a big web site release for a client and will not be able to work on it until this weekend.

Keith

@keith Good Things comes to them that wait ??

There is bad news about the plugin working with sharDB.

The sharDB plugin allows MU sites to distribute their schemas across many databases. The plugin intercepts requests and locates the right tables for a query.

My plugin does a series of SQL UNION commands to join all the comment tables together so that they can be queried. Since the sharDB schemas are distributed, using the SQL UNION request will fail.

It might be possible to query the tables individually, but that would be very abusive of resources and it would probably time out. Unless I can come up with another way to aggregate the comments tables, the sharDB system will not work.

Sorry,

Keith

@keith if i may thank you for trying ??

I will ask my buddy he he can not make a plan for use then if he gets it sorted i will ask him to give you the code ??

I will alsow give him a link to this post ??

@keith if i may thank you for trying ??