|
View previous topic :: View next topic
|
| Author |
Message |
chandracdac
New User
Joined: 15 Jun 2007
Posts: 92
Location: bangalore
|
|
|
|
HI All,
I am using SUBSTR function in one of my query and it is taking too much of execution time.. Can some one let me know how can i reduce this.. |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Not without a total blind guess. All we have seen of your code is one word.
Enter all that you think is relevant, use the Code tags to preserve formatting, use Preview to confirm it looks how you want. Complete posting and Submit. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
| it is taking too much of execution time |
It is very relative term.. some time I call 1 ms also too much time... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Why do you believe the time is due to the SUBSTR?
As mentioned, you need to post your query. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
substr() does not take long.
a where clause on substr() might. |
|
| Back to top |
|
|
cmsmoon
New User
Joined: 17 Jun 2010
Posts: 75
Location: Chennai
|
|
|
|
| Please post your sql query and how much records you want to do substring? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the TS has disappeared, little hope to get a clarification !
I really feel that the topics where the TS disappears should be deleted after a reasonable delay ( 1 month should be more than enough )
and the hope is that the TS profile skills ( surfing ) are better than the IT skills |
|
| Back to top |
|
|
|
|
