stored procedure slow

[crystalReporterNew]

Hi,
I have a simple SELECT query in SQL(with a LIKE clause in it) that runs very fast if called natively on the database prompt.It also runs equally fast as a stored procedure,however, after a long period of DB shutdown or logging off from the server and logging back in again the stored procedure is slow. If I drop and create the stored procedure again, it runs as fast as ever.What could it be? The query always runs fast at any time so it doesnt have anything to do with query caching.
Please help.
Thanks.

 

[micha123]

It might be something related to bringing the data to the adaptive server data cache.
After running it and suffering a bad performance once - have you tried running it again? have you suffer a bad performance again and again?