| Subject | Re: An SQL query perform badly after firebird database file size grow beyond 8GB |
|---|---|
| Author | Norbert Saint Georges |
| Post date | 2016-01-09T06:45:21Z |
cychau@... [firebird-support] a écrit :
SELECT MAX(A.PostDate) MaxPostDate from (
select a.postdate
FROM SL_CS A, SL_CSDTL B
WHERE A.DocKey=B.DocKey
AND A.Code='300-10001'
AND B.ItemCode='OCC'
AND B.UOM='UNIT'
AND A.Cancelled='F'
AND B.UnitPrice<>0)
--
Norbert Saint Georges
http://tetrasys.fi
>for test :
> Is this an issue related to Windows file system? Firebird service or my
> query?
SELECT MAX(A.PostDate) MaxPostDate from (
select a.postdate
FROM SL_CS A, SL_CSDTL B
WHERE A.DocKey=B.DocKey
AND A.Code='300-10001'
AND B.ItemCode='OCC'
AND B.UOM='UNIT'
AND A.Cancelled='F'
AND B.UnitPrice<>0)
--
Norbert Saint Georges
http://tetrasys.fi