See my replies below
On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br
[firebird-support] wrote:
>
>
>
> Thanks, Mark! *It worked!*
>
> I also notice something very interesting during my tests:
>
> 1. No matter if you use Firebird if a Service or Application, even without
>
Hi,
Thank you for the explanation, will optimize index, i've tried to add index
on TANGGAL_CETAK, and it really work faster and as expected, showing index
read as much as needed only, not all record.
On Tue, Jun 18, 2019 at 11:33 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support]
Hi,
The plan is using ORDER, it read through index, in my system, i need to
load 1 millions of records and i only expect the server to read 1 millions
of records only, not all the data in the table. I already use high speed m2
SSD Samsung EVO 860 series, it still need a lot of time to load.
The
Hi everyone,
I now have about 55 million data on this table, the structure is on the
first thread, i'v added index on NOMOR, the query is :
SELECT
TBAT_ITM.NOMOR
FROM TBAT_ITM
ORDER BY TBAT_ITM.NOMOR
ROWS 1 TO 100
-- QUERY PERFORMANCE --
Prepare : 94 ms
Execute :
Hi,
The data is repeated and most records are empty value, it will be filled
after a process. But will try to add index on it
Thank you
On Tue, Apr 23, 2019 at 11:35 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi
>
> As you can see, your query do not use any
Hi,
I'm using Firebird 2.5.8 win 64, i have 33 millions data on one table
Here is the DML :
CREATE TABLE TBAT_ITM (
ID_TBAT_ITM ID NOT NULL,
ID_TBAT ID,
KODE_MESIN KODE,
NOMOR ID,
TANGGAL_CETAK WAKTU,
REVISION REVISI,
CREATED_BY ID,
CREATED_DATE WAKTU,
MODIFIED_BY ID,
what is your connection string, don't use localhost:dbname format. Try use
only the filename. Try ems sql manager for firebird, it has embeded protocol
On 14 Sep 2014 19:01, Adam adam...@gmail.com [firebird-support]
firebird-support@yahoogroups.com wrote:
On Sun, Sep 14, 2014 at 9:55 PM,