July 11, 2008
A not so complex query was taking a huge time to complete (hours …).
I searched for an “EXPLAIN ANALYSE” a la PostgreSQL on MySQL … this does not exists.
They have a less featured command called “EXPLAIN EXTENDED” that outputs some interesting information.
I found that adding two indexes helped me to have the query processed in some seconds … 😉
 The EXTENDED argument did not change the ouput I had …
 Using explain from mysql website
July 9, 2008
Developping an application for a TC65 I am using Eclipse (3.1.2) with EclipseME 1.2.3.
Some annoying things :
– When calling J2ME -> Create Package, if some dependencies aren’t met, the project is not build (a logic behaviour) but no error messages are provided. Thus, when not correctly waked up, you end up with some changes in the code not replicated in the deployed jad/jar …I guess that updating to the latest EclipseME version would probably improve this.
– Obfuscation crashes whith the following error message : “Cannot run program “env”: CreateProcess error=2″ …
– Debugging from Eclipse does not work on Vista … It seems that the dial-up connection that must be started to discuss with the TC65 does not work on my Vista installation. This works fine on a XP installation. This is not an EclipseME problem but an SMTK one …
July 4, 2008
Today, I had to check that traffic between an embedded java application (in an eWON 4101) and a Coronis WavePort modem was following a given rule (less than 10 milliseconds between the bytes).
I have used a great thing : the SpyCable. It allowed me to monitor either the send traffic or the received one using two serial ports. I’ve then written a small python script to monitor the bytes entering the port, printing Coronis frames with time information if some bytes were written with more than 10 milliseconds interval.
Read the rest of this entry »
July 3, 2008
Having to write two papers to finish my master, I went back to latex this morning. Vim is still my friend 😉
Installing vim-latexsuite, makes me discover the vim-addons command used to enable/disable/… addons for vim :
# Name User Status System Status
editexisting removed removed
justify removed removed
latex-suite removed removed
matchit removed removed
ddp:/home/did$ vim-addons install latex-suite
Info: installing removed addon 'latex-suite'
Info: Rebuilding tags since documentation has been modified ...
vim-latexsuite is really nice. See http://vim-latex.sourceforge.net for more information. The problems with accentuated characters can be solved easily (vim-latex FAQ)
I manage my bibliography entries using JabRef.
July 2, 2008
Trying to have the new sms and status reports forwarded to the terminal using a TC65, it seems that AT+CNMA command is processed but not working.
In my java application, I enable the following parameters.
Then on each +CMT or +CSD, I entered a AT+CNMA=0 (because i’m in PDU mode). Answer is OK but after that, the TC65 keeps sending me the first received SMS on every entering message (status report or sms).
Finally, I had to use the AT+CNMI=2,1,0,2 and parse message from memory in place of forwarding them directly to the tc65
PS: i’m using the latest smtk (revision 3.0)