Split forum again...
Discussion
One does wonder at it all.....
I think wha ever transaction process is running on the inserts into the DB, needs a bit of a review.
It's kinda weird looking at the forum screen and seeing Last Post 22:04 and then loading the thread to see a last post of 21:35.
It's at times like this that I realise other people really do go through the same mill as I do sometimes.
Hope you can get it sorted!
I think wha ever transaction process is running on the inserts into the DB, needs a bit of a review.
It's kinda weird looking at the forum screen and seeing Last Post 22:04 and then loading the thread to see a last post of 21:35.
It's at times like this that I realise other people really do go through the same mill as I do sometimes.
Hope you can get it sorted!
_dobbo_ said:
It can't be the inserts - refreshing the post list shows a post disappear - reappear - disappear - etc.
I'd guess at some sort of replication issue.
Absolutely.... By stating 'inserts' I was considering replication.I'd guess at some sort of replication issue.
Must be they trying to load balance across a few servers?
I'd love to know which bright spark sugested that for this forum!
It's an interesting point - do you do the insert into two DBs or do you insert into one and replicate?
PH is getting big - something has to be done for performance to be sufficiently useful - either now or soon in the future, so I guess it's happening now.
In my limited experience of hacking about in a reasonably heavy database and Cold Fusion application - archiving all the older stuff off to another table keeps the wolves from the door, surely this could be done on an ongoing basis with PH?
PH is getting big - something has to be done for performance to be sufficiently useful - either now or soon in the future, so I guess it's happening now.
In my limited experience of hacking about in a reasonably heavy database and Cold Fusion application - archiving all the older stuff off to another table keeps the wolves from the door, surely this could be done on an ongoing basis with PH?
Edited by _dobbo_ on Wednesday 12th September 22:42
Gassing Station | Website Feedback | Top of Page | What's New | My Stuff







Goodnight.