JSilva
About
- Users name
- JSilva
- Joined
- Visits
- 48
- Last Active
- Roles
- Registered Users
- Thanked
- 0
Comments
-
On the other hand, and for the sake of truthness, yes, landing on calm water is survivable. This happened in Amazon (required disclosure: I used to live there, where I learnt about small airplane crashes - it happens a lot there). The aircraft ha…
-
I found this. This video shows the aircraft seconds before touch down. What you can infer from the aircraft attitude? Here, an excellent picture of the damaged wing after the landing. What you can tell from that picture?
-
alban lusitanae wrote: » @JSilva As you might expect, I am in utter disagreement with you, but let me reply to your arguments in turn, as believe you may actually be Portuguese and / or you are one who are on the side of the pilot: I have no…
-
How many of you are at least a private pilot? Or had taken some flying lessons? It would help a lot to have some empathy and try to figure out some other reasons that cowardice. Mainly came from people that probably never had to fight for his life b…
-
Einar Saukas wrote: » JSilva wrote: » Agreed, but I was arguing about one specific case - that you counter-argued incorrectly. My argument was that MySQL was wrong by behaving as stated in the bug track, not that every RDBMS was doing everything…
-
Where I wrote "(in my case, only)" please read "(in my case, only place possible)"
-
AndyC wrote: » Honestly, it's much, much easier to cache the end results you serve up (whether full pages or partial pages) via a generic web caching layer with a basic TTL on results. You'll get just as much of a saving, won't have half the heada…
-
AndyC wrote: » SQL Server inherited the bug from Sybase (and it's definitely bug!) although it's easily avoided by just adding a filter clause that excludes all NULL columns from the unique index (or at least if you don't have to work with version…
-
Einar Saukas wrote: » JSilva wrote: » ""A unique constraint is satisfied if and only if no two rows in a table have the same non-null values in the unique columns. In addition, if the unique constraint was defined with PRIMARY KEY, then it re…
-
Einar Saukas wrote: » JSilva wrote: » That's where I'm inclined to agree with @AndyC. I don't think that loading the "raw data" into memory, mimicking the table structure from the RDBMS, is a nice idea. Mimicking the table structure in memory…
-
AndyC wrote: » If I was going to build anything on top of ZXDB, it's how I'd do it, simply because it detaches the front end code from the back end structures which you have less control over. And while MySQL wouldn't be my first (or second or thi…
-
Einar Saukas wrote: » For the record, MariaDB has finally implemented CHECK CONSTRAINT last year (after I complained about it here!). ZXDB currently uses CHECK CONSTRAINT wherever it makes sense. FINALLY. One less stupidity to cope with. Do you…
-
Einar Saukas wrote: » The second level is caching the entire database as a data structure in memory. Whenever web server caching doesn't already have a specific webpage, the server will be able to quickly build this webpage simply traversing a dat…
-
(sigh) I managed to quote the wrong paragraph. =/ The following was what I intended to quote: AndyC wrote: » For an infrequently modified database, with relatively large queries you're better of using Indexed VIews (or an equivalent). The DB trac…
-
AndyC wrote: » Even with queries that can't use Indexed Views (too complex, non-deterministic, requires nested CTEs etc), you can always just MERGE the result of a select from your 50 outer joins into the contents of a caching table and still only…
-
AndyC wrote: » Einar Saukas wrote: » * Generating the complete webpage about a game requires combining data from about 50 tables, More than half of them are 1-N or N-N relations [CUT] For which the solution is Indexed Views/Materialised Views…
-
AndyC wrote: » If you can write a better in-memory solution, then you're using a terrible RDBMS in the first place. I'm not sure why modern developers always assumes that they'll write something better than systems which have had decades of tuning…
-
"Boas Festas" is usually used around here. In english, I think "Season's greetings" is the equivalent greeting.