2014年1月27日 · What I've done on performance-critical projects: Create a performance test data set; in your case, I'd load a table with 100M test records, making the best possible guess at the distribution of the data. Write the queries the application will be using to query that data; Write a test script which can execute those queries; I like Gatling.

2016年2月13日 · I think this is impacting my numbers because the database is on my local box. Edit: Had a question about doing WHERE 1=0 here (thinking that the join would happen but no output), but I tested it and it didn't work -- not a valid indicator of query performance.

2013年8月8日 · MSSQL has a database tuning advisor that will often recommend indexes for tables based upon common queries run during the tuning period, however it wo't rewrite a query for you. In my opinion, experience and experimentation are …

2015年2月17日 · An open source framework for unit test and performance benchmark, which was initiated by Andrew Zhang, under GPL license. p-unit supports to run the same tests with single thread or multi-threads, tracks memory and time consumption, and generates the result in the form of plain text, image or pdf file.

2016年7月22日 · How to test database performance. 4. Measure SQL performance without using profiler. 2.

2008年9月28日 · It also relies on artificial data, and may not expose bugs that occur due to stupid user input. Finally, if the test database is small, it won't reveal inefficiencies like a missing index. (OK, that last one isn't really what unit testing should be used for, but it doesn't hurt.) Load a copy of the production database and test against that.

2013年3月14日 · My goals are different, it's to test only database (sybase sql anywhere 9). What I need: Some tool to give a diagnostic of all sqls and find a bottleneck. I wish I could macro-view the entire system easily. Best practices to design/build a good sql queries. The system issues are: 20GB database size. 2-5 request per second

2011年4月19日 · Don't get me wrong, testing is important but mostly for the logic compared to performance testing before 11g, there are extra steps to be taken. For nice reading see Oracle® Database 2 Day + Performance Tuning Guide 11g Release 2 (11.2)

2018年10月19日 · jdbcFeeder is about driving performance tests with data read from a database (i.e. it's about "feeding" a test with data, not about testing a database). The gatling-jdbc project appears to be intended to do what you want, but it didn't work when I tried it out (Gatling 3.0-RC4). I'm pretty new to Gatling and Scala, the problem might be me, or ...

2011年1月31日 · The problem is that once I run the queries on the real database, the real database runs out of memory and starts writing things like indexes and temp tables to disk. This means that it could be that different queries would be …