cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with a SQL Query

Former Member
7,201

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:
Physical model.
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 🙂

Accepted Solutions (0)

Answers (1)

Answers (1)

Breck_Carter
Participant

Start with the following Google search

SQL database performance benchmark

and go from there... you may want to refine the search somewhat.