[MacRuby-devel] Speed

[François Boone]

Le 2011-12-21 à 15:17, Joshua Ballanco a écrit :

> 2011/12/20 François Boone <francois.boone at usherbrooke.ca>
> Hi,
> 
> I have written a function with 461 queries in a MySQL database.
> With macirb, it takes more or less 1s for all queries.
> I put my file in a Xcode project and when I click on a button, the action is to run this function.
> However, it takes more or less 1s for EACH query!
> I use normal schedule, not deployment as explained in the definitive guide,
> (I don't want give the exact title to not make advertisement  in a post lol )
> 
> What's wrong?
> 
> Hi François,
> 
> Can you give a bit more context, perhaps? In macirb, are you loading a file with the function or entering it at the prompt? In Xcode, do the queries result from a pure ruby file, or are you doing a ruby call from Obj-C? What libraries/gems are you using to connect to MySQL? Is there an 'eval' call involved in making the queries?
> 
> To be honest, things should be much faster from Xcode, since macruby_deploy will compile all of your ruby sources to .rbo files. The exception would be if your code contains copious use of "eval". It is also possible that you have stumbled on a perf bug (the best kind of bug, IMHO), in which case it would be great if you could reduce the code down to something minimal that other devs could run locally.
> 
> Cheers,
> 
> Josh
> _______________________________________________
> MacRuby-devel mailing list
> MacRuby-devel at lists.macosforge.org
> http://lists.macosforge.org/mailman/listinfo.cgi/macruby-devel

Hi Josh,

In macirb, I use:
load "actionAffiche.rb"
461 queries, real time: 11.578257s

In Xcode: 
I use rubygems and mysql macgems
I have one Button and one table with two columns: when I press the button, the function actionAffiche is running. I think that it's a complete minimal example.
461 queries, real time: 64.244236s
Apart MainMenu.xib, all my code is in AppDelegate.rb. I put this file at the end of this mail (Is there a better way?) 

I don't have control on mysql tables since they come from another software.

I am a novice, then you can criticize my code :)

Regards,
François

-------
#
#  AppDelegate.rb
#  ecm: exemple complet minimal
#
#  Created by Boone François on 11-12-21.
#  Copyright 2011 Boone François. All rights reserved.
#

require 'rubygems'
require 'mysql'

$data = []

class AppDelegate
    attr_accessor :window
    def applicationDidFinishLaunching(a_notification)
        # Insert code here to initialize your application
    end
end

class CtrButton
    attr_writer :individu
    
    def awakeFromNib
        @individu.dataSource = self
        $ref_individu = @individu
    end
    
    def affiche(sender)
        actionAffiche
    end
    
    def numberOfRowsInTableView(individu)
        $data.size
    end
    
    def tableView(individu, objectValueForTableColumn:column, row:index)
        item = $data[index]
        case column.identifier
            when 'iden'
            item.iden 
            when 'name'
            item.name 
        end
    end    
end

class Person
    attr_accessor :iden, :name
end

def actionAffiche
    
    t1 = Time.now
    # Connexion au serveur MySQL 
    begin
        dbh = Mysql.real_connect("localhost", "root", "", "Boone") 
        ## Récupération de la version du serveur et affichage
        puts "Version du serveur: " + dbh.get_server_info
        rescue Mysql::Error => e 
        puts "Code d'erreur : #{e.errno}" 
        puts "Message d'erreur : #{e.error}" 
        puts "SQLSTATE d'erreur : #{e.sqlstate}" if e.respond_to?("sqlstate")
        ensure
        dbh.query("SET NAMES utf8")
    end
        
    # Requête pour le nom de famille
    dbh.query("SET NAMES utf8")
    requete = "SELECT handle,surname FROM surname ORDER BY surname"
    reponse = dbh.query(requete)
        
    num_max = reponse.num_rows
    num = 1
        
    # Pour chaque nom de famille, on cherche le prenom
    reponse.each_hash do |lastname|
        puts "Individu " + num.to_s + " sur " + num_max.to_s
        individu = Person.new
        individu.iden = lastname["handle"]
        individu.name = lastname["surname"]
        # pour chaque nom, recherche du prenom à partir du handle.
        requete2 = "SELECT first_name,xcall FROM name WHERE handle ='" + lastname["handle"] + "'"
        reponse2 = dbh.query(requete2)
        reponse2.each_hash do |firstname|
            individu.name = individu.name + ", " + firstname["first_name"] 
            if firstname["xcall"] != ""
                individu.name = individu.name + " (" + firstname["xcall"] + ")"
            end
        end

        $data.push(individu)
        num += 1
    end
        
    # On ferme le lien mySQL
    dbh.close
        
    t2 = Time.now
    puts (t2-t1)
    # Mise à jour de l'interface
    $ref_individu.reloadData
end