Subject | Using a text file of all SQL statments |
---|---|
Author | Grant Brown |
Post date | 2005-08-23T05:19:58Z |
Hi all,
Recently, about a week ago someone on the list said that they used
dynamically loaded SQL strings that were stored in a text file. At least
I think they used a text file.
I have been thinking about this and kinda like the idea.
So my question is how does one find the required SQL string in the text
file and then load it into a query fast enough not to impact on end user
performance.
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results
Recently, about a week ago someone on the list said that they used
dynamically loaded SQL strings that were stored in a text file. At least
I think they used a text file.
I have been thinking about this and kinda like the idea.
So my question is how does one find the required SQL string in the text
file and then load it into a query fast enough not to impact on end user
performance.
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results