Home
| Calendar
| Mail Lists
| List Archives
| Desktop SIG
| Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU |
The benchmark I'm planning to write to compare MySQL and PostgreSQL, and maybe other like Oracle, is centered around a common use case. A mock social networking web site. You'll be able to see people who are logged on near you, find people by geographical radius, send messages, receive messages, post and post text. The flow is like this: First page view: logon, this is a lookup and validation, and a cookie. If no account exists, one will be created. Scan email for new messages and return a list. Next [n*2] page views will be message views, 2 for each message. A view and a response, When a message is viewed, it is updated as being viewed. When a response to a mail is sent, the new message is added to the table, and the original email is updated to reflect that it was responded. Find the person closest to you geographically, and send a message. log out. The flow will be guided by a fixed list of users and they will cycle. What do you think? Have any other tests you'd like to see? Lastly, what environment? I'm mainly a C/C++ guy, I can do PHP if need be. I could probably do Java, but I'd have to setup tomcat. Perl would just be a pain. Any suggestion? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Discuss mailing list [hidden email] http://lists.blu.org/mailman/listinfo/discuss
BLU is a member of BostonUserGroups | |
We also thank MIT for the use of their facilities. |