10,382 reputation
11336
bio website
location Munich
age
visits member for 2 years, 11 months
seen 2 hours ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


Apr
9
comment Optimizing queries on a range of timestamps (two columns)
45 milliseconds (that's 0.045 seconds) to search through 2 million rows seems quite OK to me.
Apr
9
comment PGPool Frequent Queries
The deallocate is "normal" behaviour when you use prepared statements, that shouldn't be a problem. Judging by the name of the statement that was deallocated pdo_statement I would look into whatever ORM layer you are using. This seems to be the typical (stupid) behaviour of ORMs
Apr
5
comment Convert SQL Server UPDATE Statement for Use in Oracle
@VincentMalgrat: good point regarding the alias, thanks. I simply "translated" the syntax, I wouldn't bet on the correctness though. My gut feeling is, that this could be done more efficiently using merge and window functions. But the OP didn't state what the actual problem he/she is trying to solve.
Apr
4
comment How does this undocumented syntax work? {fn CurDate()} or {fn Now()} etc
This escape syntax is supported by JDBC as well.
Apr
4
comment How I can copy from local file to remote DB in PostgreSQL?
Just enter a tab character.
Apr
4
comment How I can copy from local file to remote DB in PostgreSQL?
Well the difference is, that one reads the file on the server and the other is reading the file on the client. Obviously reading the file on the server will be faster.
Apr
4
comment How I can copy from local file to remote DB in PostgreSQL?
\copy reads a local file (it's a psql command and can only be used from inside psql). COPY however (note the missing ``) will read the file on the server.
Apr
3
comment Oracle 11g exception on fedora 14
you need to start the database instance first. emctl starts the "entprise manager", not the database.
Apr
3
comment Bandwidth comparison between log shipping and transactional replication
I would also expect this to be different depending on the DBMS in use.
Apr
2
comment Oracle equiv of T-SQL UNION ALL query
What happened when you tried?
Mar
31
comment Limiting number of results in a Partition using OVER(PARTITION BY)
The first one is the only possible way (apart from using a CTE). It's a problem with the visibility, you cannot refer to a column alias at the same "level" where you define it.
Mar
30
comment Copying my Oracle 10g Express database to another PC
That link describes a backup (and restore) using RMAN which is probably not what the OP wants (or even understands). Using DataPump is much more approriate to copy the contents of database to a different server.
Mar
28
comment How can I migrate a sybase database to mysql?
What are cots?
Mar
23
comment Why does MyISAM support FULLTEXT Searching and InnoDB does not?
Please post in english
Mar
22
comment Postgresql query speed
run explain (analyze, verbose) select ... and post the execution plan. You might want to upload it to explain.depesz.com it's easier to read that way.
Mar
22
comment effective mysql table/index design for 35 million rows+ table, with 200+ corresponding columns (double), any combination of which may be queried
I fail to see why you need 200 tables. A single table with (value_name varchar(20), value double) would be able to store everything (value_name being f1, f2, ...)
Mar
21
comment Recursive query using plpgsql
@Chau: depends on how you want to run the SQL. If that is used from inside a program, use a prepared statement (or whatever the equivalent in your programming language is). If you need to run this interactively without wanting to write the full query each time, you can wrap this query into a SQL function that accepts the "starting" ID as a parameter.
Mar
21
comment Recursive query using plpgsql
Why don't you use a recursive CTE?
Mar
20
comment help with simple sql queries
What have you tried?
Mar
20
comment Looking for performance improvements for this query
A result returned in 0 (zero) seconds is impossible. That means that the database didn't do anything.