OS :  WinXP PRO Version 2002 SP 2

DBISAM : v. 4.25b3
EDB Manage V 1.00.b6

Tables MembreN and Reservations have been extracted from PARADOX ->
DBISAM -> Migrate From DBISAM in EDB

MembreN :  2901 rows
Reservations : 111464 rows

SQL :

select R.IdMembre, M.Nom, M.Prenom,
      Count(IdMembre) as CountResPerMember
from Reservations R
join MembresN M
on R.IdMembre = M.IdMembre
group by R.IdMembre
order by CountResPerMember desc


In DBISAM this Query runs in approx. 5.2 s

In EDBM  Execute SQL fails with
   Details : Invalid pointer operation
       On EDBM exit -> AV 004BBC32 in edbmgr.exe. Read of address 00000008
           Then Runtime error 216 at 00403DAE

R.IdMembre and M.IdMembre are Integer fields and indexed.

NEXT Back in EDBM :

Open MembresN displays a correct grid.

Then modified SQL

select R.IdMembre, M.Nom, M.Prenom,
      Count(IdMembre) as CountResPerMember
from Reservations R
LEFT join MembresN M                        /* <- ADDED LEFT */
on R.IdMembre = M.IdMembre
group by R.IdMembre
order by CountResPerMember desc

In DBISAM this Query runs in approx. 5.5 s
In EDB this Query runs in approx. 17 s.

==== AND AND AND ====
-> a few result rows have empty M.Nom.   M.Prenom on these Rows is replaced
with 2 squares.
AND
-> The rows having problem with M.Nom had M.Prenom after the SQL appear now
empty on MembresN "Data" tab.

Hope this can be of any use to move on.

Regards,

Bruno Krayenbuhl

p.s. Due to exhausting problems of SPAM the e-mail address mentionned is
wrong. But I'am an ElevateSoft customer.

Bruno,

Give these queries a try with the build 7 coming out before the end of the
week.  There were a few join re-ordering bugs that have since been fixed, so
they should now run fine.

--
Tim Young
Elevate Software
www.elevatesoft.com