4,782 reputation
21529
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 4 months
seen 4 hours ago

“Well!... That takes the biscuit!”

Joyce, James. The Dubliners

The best way to speed up something is to not do it in the first place.

Kyte, Thomas.


18h
revised Oracle - Slow queries without prepending schema name or providing hint
deleted 4 characters in body
1d
revised What are the considerations for relocating BLOB storage
deleted 7 characters in body; edited tags
2d
answered Need help in putting the single quote and constant timestamp in plsql
2d
revised Need help in putting the single quote and constant timestamp in plsql
added 64 characters in body
Dec
17
comment We are trying to set up a database to be able to read and write messages on a website
This question appears to be off-topic because it is about client-side programming. Please see help center for what is on-topic on this site.
Dec
15
comment How will concurrent transactions improve speed?
Exactly the same as for your "multiprogramming" thing. If a transaction is blocked on I/O, another independent transaction can use the CPU. If they're not independent, then you'll have to wait - there's nothing specific about database transactions here.
Dec
15
comment How will concurrent transactions improve speed?
Why does your first scenario not run any of the parts concurrently? Assuming no conflicts, it could run in 3 "units".
Dec
15
revised ORA-00937: not a single-group group function
added 10 characters in body; edited tags
Dec
11
comment RAC vs Application Server Grid
I'm not sure what you mean by "application server" in this context. Are you looking at some specific docs/presentation? (If so, could you link to that?)
Dec
10
comment Solaris 10 - Why shell limits needs to be increased to run oracle database?
Shell limits affect the shell and all processes it starts.
Dec
10
revised Commit and rollback in Oracle stored procedure
added 8 characters in body; edited tags; edited title
Dec
9
comment mysql french documentation
What exactly do you expect from this question? It's not like we're going to translate all the docs in an answer here.
Nov
29
revised Import and export Excel data into a SQL server database
edited tags
Nov
27
comment Oracle redo log buffer cache vs redo log file
There's the buffer cache, and the redo log buffer. Very different things. docs.oracle.com/cd/B28359_01/server.111/b28310/…
Nov
23
comment Continuously copying an SQLite table
Triggers are run by the database engine itself. Read up on them. (In a programming language, you can do whatever you want. But if you're talking to a database, the database's rules apply. Just stop trying to busyloop to get that data, you won't make it work.)
Nov
23
comment Continuously copying an SQLite table
You fundamentally can't. If an insert+update happens between your copies, you've lost. Even with sqlite's single writer you can't make that work. Either you change the app, or your work underneath it with triggers.
Nov
23
comment Continuously copying an SQLite table
"so once updated [...]" - that's too late, it's already updated. You've lost the original. You need to copy the old value right before the update, in the same transaction, if you don't want to lose updates.
Nov
23
comment Continuously copying an SQLite table
Think about your requirements. You need to capture the value of Message right before it's updated by the app, right? If you can change the app, there's plenty of solutions. If you can't, what do you think can do something right before an update (or insert, or delete)?
Nov
23
comment Is a query inside mysql IF clause allowed?
Please edit your question to include the complete error message you're getting from that exact version of the procedure.
Nov
23
revised Is a query inside mysql IF clause allowed?
added 380 characters in body