Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 17 of 17 total
Thread SQL HELP!!
Tue, May 1 2007 6:13 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roger,

<< Is the last version of dbisam 4.xx. >>

In that case you must be trying to create a *very* large in-memory table if
you're running into memory issues.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, May 1 2007 10:57 PMPermanent Link

Dave Harrison
Tim Young [Elevate Software] wrote:

> Roger,
>
> << Is the last version of dbisam 4.xx. >>
>
> In that case you must be trying to create a *very* large in-memory table if
> you're running into memory issues.
>
Roger,
   I don't see how a memory table is going to speed things up if it has
to load all the data from disk to memory to begin with. You're only
summarizing data and there are no table joins, so I don't see the need
for the memory table, especially if you are only going to run the sql once.

Dave
Wed, May 2 2007 6:24 AMPermanent Link

"Jose Eduardo Helminsky"
Dave

<< I assume neither memory mgr is needed in BDS 2006 or later because Delphi
has its own memory mgr, correct? >>
No, you are not correct.

When I say to change DBISAMMM to FASTMM, I say you have to change this in
the DBISAM server source code, specifically in DBSRVR.DPR.

It does not matter what version of Delphi you are running, the memory
manager is *inside* DBISAM server. The main purpose is deal with database
memory allocations (and deallocations) and fastmm is better than the native
dbisammm. AFAIK, ElevateDB server is using fastmm instead of internal (from
ElevateSoft) memory manager.

I have change it some time ago and the things are quite stable so far.

Eduardo

Wed, May 2 2007 11:05 AMPermanent Link

Roger Oliveira

o que é mgr e BDS 2006?
(what is mgr and BDS 2006?)


______________________________

Dave Harrison <daveh_18824@spammore.com> wrote:

Jose Eduardo Helminsky wrote:

> Roger
>
> Change DBISAMMM to FASTMM in the dbsrvr.dpr file, recompile it and you will
> never see this increase again. And you can really trust "memory tables" in
> dbisam. I´ve used it a lot and work as expected *ALL* the times.
>
> Eduardo
>
>
Eduardo,
      I assume neither memory mgr is needed in BDS 2006 or later
because Delphi has its own memory mgr, correct?

Dave
Wed, May 2 2007 11:47 AMPermanent Link

"Jose Eduardo Helminsky"
Roger

<<
o que é mgr e BDS 2006?
(what is mgr and BDS 2006?)
>>

mgr = manager
BDS 2006 = Borland Developer Studio = #C, Java and Delphi development tools
in the same application.

BTW, are you from Brazil ?

Eduardo

Wed, May 2 2007 12:39 PMPermanent Link

Roger Oliveira

yes, i`m from brazil, porto alegre / Rio grande do sul

"Jose Eduardo Helminsky" <contato@hpro.com.br> wrote:

Roger

<<
o que é mgr e BDS 2006?
(what is mgr and BDS 2006?)
>>

mgr = manager
BDS 2006 = Borland Developer Studio = #C, Java and Delphi development tools
in the same application.

BTW, are you from Brazil ?

Eduardo

Thu, May 3 2007 6:10 AMPermanent Link

"Jose Eduardo Helminsky"
Roger

It is very good to see more brazilian people using DBISAM/ElevateDB.
I am from Piracicaba, near Campinas in SP.

I have been using DBISAM since 1.15 and it really is an amazing database
engine that supply all my needs.
If you want, you can send me private e-mails in Portuguese asking about
DBISAM. I don´t migrate to ElevateDB yet but this is on my plans during the
year.

My private e-mail is: eduardo at hpro dot com dot br

Regards
Eduardo

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image