Forum > Database

Sqldb vs Zeoslib

<< < (2/3) > >>

SunyD:
I can't say about CGI-Programs or Oracle DB but here is some RAM usage report from my 3 programs with ZEOS-Components.
I checked ram usage of 3 applications. All 32Bit, Windows XP and Zeos 7.1.3a
1. App (GUI-App)
Compiled with Delphi 7, TWebbrowser, huge GUI + Variables
12MB database Firebird 2.5 (~50.000 datarows in 24 Tables)
RAM usage: ~30MB (most of them used by TWebbrowser)

2. App (GUI-App)
Compiled with Lazarus 1.3 + fpc 2.6.4, (with embedded Forms, Lazreport, multilanguage support)
85 KB Sqlite3 database (~560 datarows in 11 tables)
RAM usage: ~20MB

3. App (GUI-App)
Like 2.App but with Firebird 2.5 Database from first app.
RAM usage: ~18MB at start, ~22-25MB after opened tabbed forms with db-components.

cahaya:

--- Quote from: miab3 on December 13, 2014, 01:35:20 pm ---@cahaya

Do Zeos compile only for Oracle, or for all databases?

Michal

--- End quote ---
Are you ask me Zeos feature or my test specification ? In my test, I use zeos for oracle db only.

miab3:
@cahaya,

Did you notice something like that in Zeos.inc?


--- Code: ---// Uncomment these defines to disable some DB drivers (reduce binary size)
{.$DEFINE ZEOS_DISABLE_MYSQL}
{.$DEFINE ZEOS_DISABLE_POSTGRESQL}
{.$DEFINE ZEOS_DISABLE_DBLIB}
{.$DEFINE ZEOS_DISABLE_ADO}
{.$DEFINE ZEOS_DISABLE_INTERBASE}
{.$DEFINE ZEOS_DISABLE_SQLITE}
{.$DEFINE ZEOS_DISABLE_ORACLE}
{.$DEFINE ZEOS_DISABLE_ASA}
--- End code ---

About what I asked.

Michal

cahaya:

--- Quote from: Soner A. on December 13, 2014, 08:01:38 pm ---I can't say about CGI-Programs or Oracle DB but here is some RAM usage report from my 3 programs with ZEOS-Components.
I checked ram usage of 3 applications. All 32Bit, Windows XP and Zeos 7.1.3a
1. App (GUI-App)
Compiled with Delphi 7, TWebbrowser, huge GUI + Variables
12MB database Firebird 2.5 (~50.000 datarows in 24 Tables)
RAM usage: ~30MB (most of them used by TWebbrowser)

2. App (GUI-App)
Compiled with Lazarus 1.3 + fpc 2.6.4, (with embedded Forms, Lazreport, multilanguage support)
85 KB Sqlite3 database (~560 datarows in 11 tables)
RAM usage: ~20MB

3. App (GUI-App)
Like 2.App but with Firebird 2.5 Database from first app.
RAM usage: ~18MB at start, ~22-25MB after opened tabbed forms with db-components.

--- End quote ---

Hi Soner,

For sqlite, 1 connection only 13Mb, but for oracle connection around 40Mb.

cahaya:

--- Quote from: miab3 on December 22, 2014, 07:45:18 pm ---@cahaya,

Did you notice something like that in Zeos.inc?


--- Code: ---// Uncomment these defines to disable some DB drivers (reduce binary size)
{.$DEFINE ZEOS_DISABLE_MYSQL}
{.$DEFINE ZEOS_DISABLE_POSTGRESQL}
{.$DEFINE ZEOS_DISABLE_DBLIB}
{.$DEFINE ZEOS_DISABLE_ADO}
{.$DEFINE ZEOS_DISABLE_INTERBASE}
{.$DEFINE ZEOS_DISABLE_SQLITE}
{.$DEFINE ZEOS_DISABLE_ORACLE}
{.$DEFINE ZEOS_DISABLE_ASA}
--- End code ---

About what I asked.

Michal

--- End quote ---
Thank you miab3. How to use that configuration file. Sorry newbie for zeos and lazarus.
But fcgi program around 2,7Mb in size.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version