on 2013 May 06 5:59 PM
Hello,
I would appreciate a little help with a little research I'm doing.
I have created a small database, which model can be seen here:
.
I have about 20 products (rows), 100 customers, 7 credit cards, 10 000 payments, 20 000 orders and ~219 000 ordered_products.
My goal is to compare Sybase's data retrieval effectiveness and speed to some other DBMS-s, but I haven't figured out, what query (or queries) should I use to effectively reach that goal. I was planning to create one to three queries, which would use as much tables as possible and result in at least about 1000 rows.
I am not really experienced in databases yet and that's why I am struggling with this.
Thanks in advance 🙂
Request clarification before answering.
Start with the following Google search
SQL database performance benchmark
and go from there... you may want to refine the search somewhat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
45 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.