4,717 reputation
21529
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 3 months
seen 11 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.


2d
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.)
2d
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.
2d
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.
2d
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)?
2d
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.
2d
revised Is a query inside mysql IF clause allowed?
added 380 characters in body
2d
comment Continuously copying an SQLite table
The only sane way of doing this AFAIK is to use triggers on the table. Have you tried that already?
2d
revised Continuously copying an SQLite table
deleted 8 characters in body; edited tags; edited title
Nov
20
revised How to determine if open_table_cache is set properly?
edited tags
Nov
19
revised How to determine if open_table_cache is set properly?
added 20 characters in body; edited title
Nov
18
comment Why does dmbs_xmlgen.convert only decode some entities?
♥ isn't a standard XML entity (there's very few of those). Could you show an example with one of your Chinese chars, and please specify your locale settings.
Nov
18
awarded  Enlightened
Nov
18
revised ORA02063 error while connecting to remote databse
edited tags
Nov
18
awarded  Nice Answer
Nov
17
comment SQL Server Standard Edition Memory Limit
@spaghettidba: I'm guessing those are for the "does not show research effort" downvote reason. It's a legitimate question, but its answer can be found in the docs. (In fact you don't even need to reach the docs, typing the question title in Google reveals the answer in a fancy Google box thing.)
Nov
17
comment Indexing in SQL Server
How or when to use indexes depends on the details of your tables and queries. You don't supply enough information for anyone to help you out here. We'd need details, including schema, queries, and execution plans to give good advice.
Nov
17
reviewed Edit suggested edit on Cannot drop databse
Nov
17
revised Cannot drop databse
Formatting
Nov
17
comment DBA MySQL experience
Please see the help center for what topics we cover on this site. (And take the tour.) This sort of question is not in scope.
Nov
17
revised Optimize this query
added 226 characters in body