Archive for the tag "Database"
Extreme performance in database – the server side java symposium
March 18th, 2011 by Jeanne BoyarskyI wasn’t sure whether to blog about this session. Scott feels i haven’t written enough here at the Server Side Java Symposium so i decided to go for it . Unfortunately, he didn’t say anything I could write without doing a free press release. So here’s a really short summary. The one slide is an [...]
Posted: 18 March, 2011 in Java/J2EE.
Tags: Database, performance, tssjs
Comments: 1
Memo: Avoid Functions in Database Queries
October 21st, 2010 by Scott SelikoffThe most common type of questions in the JavaRanch JDBC forum tends to be about improving performance in a database (that, and “Where can I download a JDBC Driver?”). While remote trouble-shooting performance issues can be tricky, we often spot issues with the presented queries and offer alternatives to improve performance. One issue I see [...]
Posted: 21 October, 2010 in Database, JDBC.
Tags: Database, function, functions, index, javaranch, JDBC, mysql, queries, query
Comments: 2
clone a postgresql database for testing cleanly
March 28th, 2010 by Jeanne BoyarskyI’m looking at writing integration tests for the back end of JavaRanch‘s JForum install. A few “pesky” requirements/constraints Multiple developers all over the word have their own local test databases filled with data in different states. The tests must work for everyone. Ideally they won’t leave data floating around either. The tests must use PostgreSQL. [...]
Posted: 28 March, 2010 in JavaRanch, JDBC.
Tags: Database, JDBC, jforum, postgresql
Comments: 4
