<html>
<body>
Hi,
<br>
<br>
Am 01.04.22 um 14:20 schrieb Devang Dhandhalya via FreeSWITCH-users:
<br>
<font color="#000000">> and rate=(select min(rate) from deckrate where
</font><br>
<font color="#000000">> code=SUBSTRING('12345566878',1,length(code))) limit 1
</font><br>
<br>
Here is your problem. That statement will mean that your database will
<br>
have to manually go through _all_ entries in the decrate table as it
<br>
needs to calculate the SUBSTRING for every entry.
<br>
<br>
The better solution is to have an index on "code" an a query like...
<br>
code in ('12345678', '1234567', '123456'...'12','1')
<br>
<br>
With such a query the index will be used and it'll be _much_ faster.
<br>
<BR />
<BR />
Christian Berger<br><br><br> <img src="cid:0eb5f48c.e33a6fec.jpg.9ec4ca21" width="119" height="64"><br><br>foncloud GmbH & Co KG<br>Hahlweg 2a<br>36093 Künzell<br><br>Tel: / <br>Fax: +49 661 968990-99<br><br><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<p class="MsoNormal"><span style="font-size:10.5pt; mso-ascii-font-family:
calibri; mso-fareast-font-family:" times new roman" mso-hansi-font-family:calibri; color:black; mso-ansi-language:en-us;" lang="EN-US">Email: </span><span style="font-size:10.5pt; mso-ascii-font-family:calibri; mso-fareast-font-family:
" times new roman" mso-hansi-font-family:calibri; color:black; mso-ansi-language:
en-us;" lang="EN-US">Christian.Berger@foncloud.net<br>
Web: <a href="http://www.foncloud.net "><span style="mso-ascii-font-family:calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:calibri; mso-fareast-theme-font:
minor-latin; mso-hansi-font-family:calibri; mso-hansi-theme-font:minor-latin; color:black; text-decoration:none; text-underline:none;">www.foncloud.net</span></a><br></span></p><p class="MsoNormal"><br><span style="font-size:10.5pt; mso-ascii-font-family:calibri; mso-fareast-font-family:
" times new roman" mso-hansi-font-family:calibri; color:black; mso-ansi-language:
en-us;" lang="EN-US"></span><span style="font-size:7.5pt; mso-ascii-font-family:calibri; mso-fareast-font-family:
" times new roman" mso-hansi-font-family:calibri; color:black; mso-ansi-language:
en-us;" lang="EN-US"></span></p><div><div class="moz-text-html" lang="x-unicode"><div class="WordSection1"><p class="MsoNormal"><b><span style="color: black;">P.S.: Wussten Sie schon?<span class="apple-converted-space"> </span></span></b></p><p class="MsoNormal"><b><span style="color: black;">Unter<span class="apple-converted-space"> <a href="https://www.foncloud.net/wissen">https://www.foncloud.net/wissen</a> </span>finden Sie zahlreiche Informationen und hilfreiche Artikel rund um unsere Produkte und Services.</span></b></p><p class="MsoNormal"><span style="font-size:11.0pt;"> </span><font size="1"><br></font></p><p class="MsoNormal"><font size="1">Registergericht: Amtsgericht Fulda, Persönlich haftende Gesellschafterin der foncloud GmbH&Co.KG: Global Brain Network GmbH</font></p></div></div></div><font size="1">Geschäftsführer der Global Brain Network GmbH: Peter Krug Sitz der Gesellschaft: Künzell.<br><br>Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.<br><br>This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.</font><br><br><br><BR />
</body>
</html>