Hello folks,
my "problem" is solved - using the tip from Mahdu.
Thanks to all for this great support - far away from .NET Provider issues :-)
ThanksNielsIf i chance my slow version of the procedure from (A)CREATE PROCEDURE KI_SUCHEPERSONEN_HELP2( SUC
At 10:13 AM 25/03/2008, you wrote:
>> (Helen) 1. The index isn't available if you use LIKE.
>No. If I execute the query out of the procedure and have a look of the
>performance analysis (shown from IB-Manager from EMS) the query was executed
>by using indexreads :-). This looks like using the in
Hi folks
what a great response. Thanks a lot.
Some remarks from me:
(Juri)
>AFAIU the problem, the first procedure (without exec stmt) runs very
>slowly and the second (same statement, but only executed thru exec
>stmt) runs fast. Or did I miss something?
Thats correct. I am just wondering about
At 01:37 AM 25/03/2008, you wrote:
>Hi forum!
>My problem is not related to the provider (thanks for your great work at this
>topic, it runs perfect for me), but perhaps you can help me.
>
>If I run this procedure it take 1,7 seconds !!! to finish.
>The code runs again a table witch have 400.000
By the way, you should have an index on SuchName field!
Regards,
Paul
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ulrich Niemand
Sent: Monday, March 24, 2008 4:37 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Peformance running a
24, 2008 4:37 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Peformance running a procedure
Hi forum!
My problem is not related to the provider (thanks for your great work at this
topic, it runs perfect for me), but perhaps you can help me.
If I run this
try -
where SuchName *STARTING WITH* :SuchName1;
On Mon, Mar 24, 2008 at 12:17 PM, Slavomir Skopalik <[EMAIL PROTECTED]>
wrote:
> Hi,
> the LIKE statement is very complex and in some cases it can used index.
> .. WHERE aaa LIKE 'aaa%'
>
> and in outher not:
>
> ... WHERE aaa LIKE '% aaa'
>
> SP m
Hi,
the LIKE statement is very complex and in some cases it can used index.
.. WHERE aaa LIKE 'aaa%'
and in outher not:
... WHERE aaa LIKE '% aaa'
SP must create plan when you are preparing statament and this is before
sending parameters.
In second case, you run SQL on fly and in this case the p
On 3/24/08, Slavomir Skopalik <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
> this is because LIKE operator in general case CAN'T use a index.
> You must equal or other operator instead.
>
> Slavek
>
> PS: Like in this case is dangerou because huge performance penalty
> (try use second case with Su
TECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Ulrich Niemand
Sent: Monday, March 24, 2008 3:37 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Peformance running a procedure
CREATE PROCEDURE KI_SUCHEPERSONEN_HELP2(
SUCHNAME1 VARCHAR(200) CHARAC
> Thanks in advance for any help or a hint to a forum with could help me.
> Happy easter.
Hello, better to ask in fb-support list.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
---
Hi forum!
My problem is not related to the provider (thanks for your great work
at this topic, it runs perfect for me), but perhaps you can help me.
If I run this procedure it take 1,7 seconds !!! to finish.
The code runs again a table witch have 400.000 rows and a index on field Suchname.
CR
12 matches
Mail list logo