10 interessanti domande su MySQL

10 questions on MySQL speed-up and optimizations

http://www.jpipes.com/index.php?/archives/177-Common-Questions-and-Answers-from-Performance-Tuning-Webinars.html

Which will be faster out of these two queries - one with OR or one with IN?
Where does MyISAM cache table records?
Which will be faster out of queries with explicit INNER JOIN and implicit one?
Is InnoDB faster/better than MyISAM?
Is CHAR faster than VARCHAR?
Is VARCHAR(80) faster than VARCHAR(255)?
Are there performance issues when joining tables from different storage engines?
If I change a derived table to a view, will performance increase?
If I see Using temporary; Using filesort" in the Extra column of
EXPLAIN output, does that mean a temporary table is created on disk?
Is it possible to do a FULL OUTER JOIN in MySQL?

Commenti

Posta un commento

Post popolari in questo blog

Nokia PCSuite and Outlook (Sync Other Phone Number issue)

This macro correct Contact issue about Other Phone Number syncing contacs from Nokia Phone and Outlook. How to use it: Open Outlook Alt+F11 (or go to Tools - Macro - Visual Basic Editor) Open the current project from the left panel: Project1 - Microsoft Office Outlook - This Outlook Session Copy and Paste the Sub CorrectNokiaContacts() (Fix the red line) Correct AreaCode variable with your (+39 is for Italy) Press F5 to run Now you can re-sync your Nokia phone or Windows Mobile.
Continua a leggere

Eclipse underscore not visible

Immagine
Problem: Underscore is not Visibile on Ubuntu With: Eclise Luna SR2, Mars 2, Neon 1a on Ubuntu 16.04 LTS After few tests I understand this  is because my Ubuntu has text scaling factor set to 1.05 (from Unity Tweak Tool) Solution #1 text scaling factor set to 1.00, but for me is too small (you need to restart eclipse to see changes when you change Ubuntu text scaling factor) Solution #2 change only the default font in Eclipse with Liberation Mono (text scaling factor set to 1.05 as default) (for me the best solution at the moment, good font, good size, system text scaling factor set to 1.05 is good also for other applications like terminal)
Continua a leggere

Come configurare Chromebook per lo sviluppo JavaScript e Nodejs

Da tempo mi chiedevo come "sblindare" il Chromebook per provare ad usarlo come postazione per lo sviluppo. Cercando online ho capito che ci sono diverse strade, e che essenzialmente possonon funzionare o meno anche in funzione del processore del Chromebook. Nel mio caso un Acer Chromebook R 13 che monta processore ARM, un MediaTek MT8173C (ovvero 4 core architettura Armv8-A: 2 x Cortex-A72  e 2 x Cortex A-53 a 64 bit). Ho scoperto che ci sono essenzialmente tre strade: 1) installare i tool mancanti e package manager direttamente sull'Os ChromOS ( crew ) 2) installare un ambiente chroot con una versione di Ubuntu 16.04 LTS ( cruton ) 3) installare un ambiente "android" completo come App dal Play Store.
Continua a leggere