Speed on Networking access.

[Carlopiza]

Hi 2 All

Does HMG Extended and HMG Official shared the same codebase (at least inittialy)? ; I ask this because there was an issue comparing ooHG vs. HMGExt; The problem looks like when u use shared dbf databases on a network lan, the program written in HGMExt can go very slow ( at least compared with ooHG). Is there any kind of similar issue here in HMG Official?; I have tried some examples and have not notice the slowdown (In HMGExt), but several people have suffered from that so there must be some true there.

Anyone here have applications (made in HGM Official) running big dbf databases on a shared lan and have not problem with this slowdown issue?.

Carlos

[Rathinagiri]

Sorry Carlos,

I don't use dbf now-a-days, except in some old single user systems. Therefore, I could not answer your question properly. May be some others may answer.

[mol]

I've used dbf files, where 1 file was about 40MB large.
It worked enough quick in my opinion.
In my new billing app, I used dbfs too. I think it works OK. Problem was with Browse, I've used too much refresh function. When use of refresh was limited, application works quickly on terminals.

Marek

[Carlopiza]

Tks to rathinagiri and Morek for their answers. Morek, obviously , you are using HMG official, not extended?

It's true that it will be a lot better to use SQL for network applications, but I have 2 huge programs that use DBFs and have no issues, except the ocassionally and almost inevitable data corruptions that I resolve using daily backups. And to be honest, if they will not pay me for change it to SQL, why I will do it?

I take the opportunity to ask two questions about the subject :

1 - Does MySQL is free or not to deploy in enterprises?; I have not a clear understanding of this.

2 - I know this is the Official version forum, but, Is there a well known reason to use it or the Extended?; Looks like the future development will go mainly for the 4.X version and the Windows version will get only ocassionally fixing patches.

3 - Anybody have try Firebird SQL with HMG?; It's complete free and looks very interesting, but not so popular like MySQL.


Carlos

[Rathinagiri]

I take the opportunity to ask two questions about the subject :

1 - Does MySQL is free or not to deploy in enterprises?; I have not a clear understanding of this.

2 - I know this is the Official version forum, but, Is there a well known reason to use it or the Extended?; Looks like the future development will go mainly for the 4.X version and the Windows version will get only ocassionally fixing patches.

3 - Anybody have try Firebird SQL with HMG?; It's complete free and looks very interesting, but not so popular like MySQL.
Carlos

Hi Carlos,

These are the answers to your questions as far as I know.

1. Yes. MySQL is free. The thing is, you can not bundle MySQL along with your software and sell. If you want to bundle then yours should also be an Open Source Software. Now, how to overcome this? You just ask your client to download and install MySQL in their system. You then install your software using MySQL. I think that won't create any problem.

2. You can use official or extended version as you wish. Even though the operation/commands are same, both of them are different. More features = extended. More stability = official. This is my opinion only.

3. Yes. I have used Firebird SQL and PostgreSQL. I even coded a bridge for SQLite, MySQL and PostgreSQL so that you need not change any code in your source code when changing from one SQL to another.

[Carlopiza]

Tks for the reply Rathinagiri.

One last question ; Curious about, how do you access the firebird database in HMG, through ODBC or Directly?

[Rathinagiri]

Tks for the reply Rathinagiri.

One last question ; Curious about, how do you access the firebird database in HMG, through ODBC or Directly?

Directly!