Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQL Benchmark, what environment?

 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]

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /