4
Answers

Does Cast() and Convert() make query performance low??

Photo of ajaz N

ajaz N

10y
815
1
In my query i have cast and convert functions,which made my query run for long time.
When i removed those functions and replaced them with day/month/year functions and concatenated them for getting a format of date
which took less time.
Is this because convert() or cast() takes more execution time ?
 
Thank you
in advance

Answers (4)

0
Photo of theLizard
NA 5.1k 282.3k 15y
Hello patrick,

You need to setup DSN's (Data Source Names) on each machine, this can be done programatically but you do need to have the ODBC Drivers or the MySqlConnector dlls on those machines.


0
Photo of Lalit M
NA 6.7k 48k 15y
hi,

show her discus how to configure mysql server in remote computer

For Connection string

Thanks,