high-volume

Time Calendar Data Structure

We are looking at updating (rewriting) our system which stores information about when people can reserve rooms etc. during the day. Right now we store the start and time and the date the room is available in one table, and in another we store the individual appointment times. On the surface it seemed like a logical idea to store the ...

What happens if a message is rolled back in MQ?

Hi, I receive a message from a WebSPhere MQ queue. I try to process and if i receive some exceptions i want to rollback the message to the MQ Queue. I have no problems in doing the same. What happens to the message? Does it go to the bottom of the queue? If i try and pull a message from the queue would i receive the same message that ...

Dealing with a high volume of data from client to server over HTTP

Hi all, For a personal project ive created an asynchronous TCP socket server that has two types of clients, listeners and senders. Sending clients are iphones and write data about 5 times per second, which is then relayed to listening clients. This has worked fine so far, being fast and efficient, but for scalability and stability im th...

Database design with millions of entry

Suppose there is a messaging system. This system has millions of entry to be sent and get reported and the count is growing by 100K every hour. 2 service accesses db, one is sender, one is reporter. So what would you suggest in order to get maximum performance? How could the db be designed? Also what open source RDBMS would you suggest ...