• Post Reply Bookmark Topic Watch Topic
  • New Topic

Optimise database queries  RSS feed

 
Peter Straw
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to find a way to send at least 5000 statements/second to a remote database. Would it be possible to do this by writing a java app and use jdbc? If so, how could this be implemented please?

Basically it is a performance test for our database proxy. The remote database is sql server, and the actual queries sent could be the same ("select 1"?) but I'm not sure how to ramp up the speed.

Many thanks.
 
Scott Selikoff
author
Bartender
Posts: 4081
21
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Depends, is the testing application on the same computer as the database? Probably not based on your information.

The problem you are likely to have though, is if you structure one query per network call, network traffic will likely dominate over database usage. Translation being, you'll be performance testing your network cards and network bandwidth rather that the system.

As part of performance testing (and yes I'm moving this to the performance forum), its good to send 'sets' of sql queries from multiple different machines. For example, have 10 computers each making 500 queries per call. This will allow you to see if there are likely to be concurrency issues. You could also structure it so that each query is a user, and each computer then represents 500 users.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!