Re: [Firebird-devel] Memory usage in Firebird

2012-03-18 Thread Jesus Garcia
2012/3/18 Mark Rotteveel m...@lawinegevaar.nl > The working set size is the amount of memory currently paged into > physical memory, not the total (virtual) memory size of a process (see > > http://msdn.microsoft.com/en-us/library/windows/desktop/cc441804%28v=vs.85%29.aspx > ) > > If Firebird is n

Re: [Firebird-devel] Memory usage in Firebird

2012-03-18 Thread Mark Rotteveel
On 12-3-2012 10:40, Jesus Garcia wrote: > Of course, do you want that i send it you in the ticket i opened about > memory usage in Fb2.1 and fb 2.5? > I have prepared a script for create database, a little aplication to > open connections and tables and a word document explaining the steps. > I als

Re: [Firebird-devel] Memory usage in Firebird

2012-03-13 Thread Jesus Garcia
> > If you need it i can backup only metadata. > > > > Please do. > > You have it in the tracker -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developer

Re: [Firebird-devel] Memory usage in Firebird

2012-03-13 Thread Alex Peshkoff
On 03/13/12 12:45, Jesus Garcia wrote: > 2012/3/13 Alex Peshkoff > >>> Sorry, is Delphi, but i supply sources. Are very simple. >>> >> hmm - will try to reproduce... >> > The script source has been extracted with ibexpert, don't know if is > compatible with isql. No. > If you need it i can bac

Re: [Firebird-devel] Memory usage in Firebird

2012-03-13 Thread Jesus Garcia
2012/3/13 Alex Peshkoff > > Sorry, is Delphi, but i supply sources. Are very simple. > > > > hmm - will try to reproduce... > The script source has been extracted with ibexpert, don't know if is compatible with isql. If you need it i can backup only metadata. To reproduce the problem, just write

Re: [Firebird-devel] Memory usage in Firebird

2012-03-12 Thread Alex Peshkoff
On 03/12/12 14:15, Jesus Garcia wrote: > 2012/3/12 Alexander Peshkov > >>> I have prepared a script for create database, a little aplication to >>> open connections and tables >> Would be great if it's isql or at least something OS independent >> >> >> > Sorry, is Delphi, but i supply sources. Ar

Re: [Firebird-devel] Memory usage in Firebird - Email found in subject

2012-03-12 Thread Leyne, Sean
> > Why max momory Allocated is near 30MB more than max memory used? > > Looks like fragmentation and losses in memory manager > > > I have attached everything to CORE-3560, but i have seen is closed. > > Thanks, Jesus I have re-opened the case. Sean --

Re: [Firebird-devel] Memory usage in Firebird

2012-03-12 Thread Jesus Garcia
2012/3/12 Alexander Peshkov > > I have prepared a script for create database, a little aplication to > > open connections and tables > > Would be great if it's isql or at least something OS independent > > > Sorry, is Delphi, but i supply sources. Are very simple. > > and a word document expla

Re: [Firebird-devel] Memory usage in Firebird

2012-03-12 Thread Alexander Peshkov
В Пн., 12/03/2012 в 10:40 +0100, Jesus Garcia пишет: > > > 2012/3/12 Alexander Peshkov > > That's very interesting effect. Can you prepare a testcase to > look at > it? > > Of course, do you want that i send it you in the ticket i opened about > memory usage i

Re: [Firebird-devel] Memory usage in Firebird

2012-03-12 Thread Jesus Garcia
2012/3/12 Alexander Peshkov > > That's very interesting effect. Can you prepare a testcase to look at > it? Of course, do you want that i send it you in the ticket i opened about memory usage in Fb2.1 and fb 2.5? I have prepared a script for create database, a little aplication to open connect

Re: [Firebird-devel] Memory usage in Firebird

2012-03-12 Thread Alexander Peshkov
В Вс., 11/03/2012 в 18:06 +0100, Jesus Garcia пишет: > 2012/3/11 Alex Peshkoff > > > > What is the real RAM needed for each connection? > > That depends first of all upon the metadata, needed at he > given moment > of time. > > I understand, but how

Re: [Firebird-devel] Memory usage in Firebird

2012-03-11 Thread Jesus Garcia
2012/3/11 Alex Peshkoff > That's sooner of a kind of OS-specific effect. Such small working set as > 1Mb is too small for firebird. > I think so, but what is the real amount of memory needed for metadata itself, 8 Kb or 25000 Kb? When the working set decreases and after that i execute one qu

Re: [Firebird-devel] Memory usage in Firebird

2012-03-10 Thread Alex Peshkoff
On 03/11/12 03:03, Jesus Garcia wrote: > Sorry for post something posted in firebird support, but i have not had any > response and may be developers can do. > > I'm trying to understand the memory usage with classic server 2.5.2 32/64 > bits with cache pages set to 75/300. > > Our production data