Jump to content

I used to have "Out of memory" problem


Kachar ganyalong

Recommended Posts

I used to have this problem with the older 0.9  trial version , now I've purchase the license and download the latest.

 

the old setting that caused problem:

Delphi 2010

unigui 0.9

Firebird 2.5

IBX

I use IBDATASET to connect

link unidatagrid to Ibdataset

 

 

Error are:

1. Out of memory - this one, I think it is because the " select * " (I have checked Task manager, It was using massive RAM) -> SQL should fix by limit record request

 

2. "Access violation" when new user enter the web and click login. it will send SQL to Firebird sever and it Error-> this happen randomly and when it happened, it always  happen until restart.

      I think it's cause by IBX or Firebird transaction so I will change to MySQL

 

 

new setting i will use:

Delphi 2010

Lastest Unigui

MariaDB

ZEOS

clientdataset connected to ZeosDataset

Fastreport -> each report will have it own Database connection (ZeosFrxDB)

 

will it ok? any recommendation? is ADO better?

 

 

 

 

I will re-create my project by using this demo(is it the best practice?) :"Demo_FastReport_corrected.rar" from http://forums.unigui.com/index.php?/topic/2669-fastreport-demo/?hl=fastreport  

Link to comment
Share on other sites

Where is your connection object ( TZConnection) placed ? Put it either on UniMainModule or on a Datamodule created by each session.

NOT on UniServerModule. Connection object cannot be "shared" between sessions.

IBX and Zeos, at least the last versions I worked with were threadsafe.

I had  problems with Zeos + Firebird 2.5 receiving strange errors at connection time.Sharing violations.

Try IbDac or UniDac . It really works and you have FastReports connector right from the box.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...