Subject | Re[2]: [firebird-support] Additional optimalization |
---|---|
Author | Roland Turcan |
Post date | 2009-01-02T21:50:38Z |
Hello Dimitry,
Thanks for your fast answer, but of couse I did try to put it into FOR
SELECT loop, but I don't see it faster but slower.
IMO, I don't think that it takes for Firebird where FAKTURY has about
5000 recs and SALDOKONTO has about 10000 recs few seconds.
There must be a trick to get it faster.
TRoland;
<<< 2.1.2009 18:11 - Dimitry Sibiryakov "sd@..." >>>
DS> SY, SD.
DS> ------------------------------------
DS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DS> Visit http://www.firebirdsql.org and click the Resources item
DS> on the main (top) menu. Try Knowledgebase and FAQ links !
DS> Also search the knowledgebases at http://www.ibphoenix.com
DS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DS> Yahoo! Groups Links
--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk
Thanks for your fast answer, but of couse I did try to put it into FOR
SELECT loop, but I don't see it faster but slower.
IMO, I don't think that it takes for Firebird where FAKTURY has about
5000 recs and SALDOKONTO has about 10000 recs few seconds.
There must be a trick to get it faster.
TRoland;
<<< 2.1.2009 18:11 - Dimitry Sibiryakov "sd@..." >>>
>> Any idea?DS> I would decompose it into inside of FOR SELECT loop.
DS> SY, SD.
DS> ------------------------------------
DS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DS> Visit http://www.firebirdsql.org and click the Resources item
DS> on the main (top) menu. Try Knowledgebase and FAQ links !
DS> Also search the knowledgebases at http://www.ibphoenix.com
DS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DS> Yahoo! Groups Links
--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk