[Gambas-user] Slow Mysql connection

[juanramon at ...1546...]

Ok Benoit,

1.-I connect to an external database via Internet. Is a Public Function in
Modul :

  PUBLIC FUNCTION ConectarBase() AS Boolean

   IF MComun.Conectar <> NULL THEN RETURN FALSE

   MComun.Conectar = NEW Connection
   WITH MComun.Conectar
    .Host = "XX.XX.XXX.XXX" .-Static IP
    .Name = "instore"
    .Type = "mysql"
    .Login = "XXX"
    .Password = "XXXX"
   END WITH

   TRY MComun.Conectar.Open()
   IF ERROR THEN
    MComun.Conectar = NULL
    Message.Error("ERROR AL CONECTAR CON LA BASE DE DATOS")
    RETURN TRUE
   END IF

   RETURN FALSE

 END

2.- I verify connection problems to enter de Database in FormMain:

  PUBLIC SUB Form_Open()

   ME.Center()

   IF MComun.ConectarBase() THEN
      Message.Info("NO S'HA POGUT FER LA CONNEXIO")
      RETURN
   END IF

  END

3.- Open Forms selecting in the Menu:

  PUBLIC SUB Caixeres_Click()

   DIM Caixeres AS FormCaixeres

   Caixeres = NEW FormCaixeres(ME)
   Caixeres.Show()

  END

  One function for each option of the menu that opens a new form

Each form consists of a diferent DataSource connected to diferents tables
of the DataBase and many “DataControls”

When I open a form for the first time goes very slow,  when opening for
the second time it's a normal function.

Thanks,

> On Thursday 24 August 2006 14:07, juanra wrote:
>> hi!!
>>
>> I'm working with a mysql connection, using many forms. All its ok but it
>> works slowly.
>> i connect to the database with the main form, then when i open some
>> other form with datasources inside it, the form opens slooooowly, first
>> then the second and all others opens quick.
>> why???? can you help me.
>>
>> to open the form i use the code:
>>
>> PUBLIC SUB Caixeres_Click()
>>
>>   DIM Caixeres AS FormCaixeres
>>
>>   Caixeres = NEW FormCaixeres(ME)
>>   Caixeres.Show()
>>
>> END
>>
>> yours faithfully Juanramon
>>
>
> We can't read mind yet! :-)
>
> You must give full details about your application, and/or send your
> project.
> Did you put internet between your database and your gambas program?
>
> Regards,
>
> --
> Benoit Minisini
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>