[firebird-support] Re: Problem in fetch records

2011-09-03 Thread trskopo 
Hi Cornie, thanks for your answer.

I am using TIBQuery and there is no PacketRecords and FetchOnDemand property 
for TIBQuery.

Best regards,
Sugiarto

--- In firebird-support@yahoogroups.com, Cornie van Schoor cornievs@... wrote:

 On 03/09/2011 13:54, trskopo wrote:
  Hi all,
 
  Here is the problem, when I issued Select SQL statement, sometime, not
  all records fetched, but this was not always happen, sometime, all
  records fetched ok.
 Check your dataset in c++, maybe it set to retrieve in only x of amount 
 of records per fetch.  PacketRecords = 100 (-1 means fetch all).  If 
 FetchOnDemand is True, scrolling a grid for example, will force fetching 
 of more record as required.
 
 Regards
   Cornie

[firebird-support] Re: Problem in fetch records

2011-09-03 Thread trskopo 
Hi Alan, thanks for your answer,

My SQL statement is like this :
select a.*, b.nm from T_IN_OT1 a, m_src b
where a.is_cls  'T'
and a.id_cst_sppl = b.id
order by a.frm_N desc

Before run this statement, I call stored procedure to calculate stock 
calculation, it is quiet a heavy procedure.

I am using AMD 6 cores only for testing, because the application is not complex,
and I believe Intel Dual Core E5700 is enough.

I think, on Win7, there is some delay in when retrieved data, could it be I
should change UsePriorityScheduler, PrioritySwitchDelay, and PriorityBoost
parameters in firebird.conf?

Best regards,
Sugiarto

--- In firebird-support@yahoogroups.com, Alan J Davies Alan.Davies@... wrote:

 Don't think its Firebird. I have applications running on lower
 specification systems with none of these problems, on windows XP, server
 2003 and on Linux. Also on Win7.
 What is your statement? Are there any parameters or where statements?
 However, if it works on the other syste, why not leave it there?

  Total records is about 5000 data.
 
 That's not a problem - Firebird would handle this in a blink of an eye!

 Alan J Davies
 Aldis