gmartins77
asked on
problem with locate method
Hello.
I'm having memory problems when using the locate method. I'm using an
IBTable(Interbase). I've also tried with IBDataSet. The problem is the same.
The strange thing is that it depends on the tables I use...
When I do the following code:
FrmDados.Tabela_Amostra.ac tive:=TRUE ;
existe:=FrmDados.Tabela_Am ostra.loca te('chave_ carta_fk;n um_amostra ',VarArray
Of([car.chave_carta,namo]) ,[]);
the memory allocated increases a lot (sometimes 3 times more; I'm checking
the memory with GetHeapStatus.TotalAllocat ed).
But when I run this code:
FrmDados.Tabela_Pesagem.ac tive:=TRUE ;
existe:=FrmDados.Tabela_pe sagem.loca te('chave_ amostra_fk ;n',VarArr ayOf([chav
e_a,pes.N]),[]);
the memory sometimes decreases!!!! The tables are not the same, but the
second table has more records than the first!
Can anyone give me some tips on how to avoid this memory problem?
Thanks
Goncalo
I'm having memory problems when using the locate method. I'm using an
IBTable(Interbase). I've also tried with IBDataSet. The problem is the same.
The strange thing is that it depends on the tables I use...
When I do the following code:
FrmDados.Tabela_Amostra.ac
existe:=FrmDados.Tabela_Am
Of([car.chave_carta,namo])
the memory allocated increases a lot (sometimes 3 times more; I'm checking
the memory with GetHeapStatus.TotalAllocat
But when I run this code:
FrmDados.Tabela_Pesagem.ac
existe:=FrmDados.Tabela_pe
e_a,pes.N]),[]);
the memory sometimes decreases!!!! The tables are not the same, but the
second table has more records than the first!
Can anyone give me some tips on how to avoid this memory problem?
Thanks
Goncalo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A locate should be that last thing to be used in order not to increase the memory usage!
U should also take a look at IBSQL component in order to execute a query with a minimum overhead!
Espero q tenha ajudado! (Vi o português no nome das suas tabelas).
VSF
www.victory.hpg.com.br
www.boatoda.hpg.com.br
www.enge.cjb.net
U should also take a look at IBSQL component in order to execute a query with a minimum overhead!
Espero q tenha ajudado! (Vi o português no nome das suas tabelas).
VSF
www.victory.hpg.com.br
www.boatoda.hpg.com.br
www.enge.cjb.net
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Split between kretzschmar and dMa
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Paul (pnh73)
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Split between kretzschmar and dMa
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Paul (pnh73)
EE Cleanup Volunteer
then supply the table with indexes on the to locate fields
meikl ;-)