Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link SQL Related Articles: Use MSSQL Index Tuning Wizard to optimize database access 2004-07-19 -- Ralph Tartaglia Newsgroups: comp.lang.clarion
> I found a way around my problem.
>
> BUFFER(MyView,3000,0,0,0)
>
> Went from 20 seconds to 1 second.
>
> What a difference.
>
> In my case I'm reading the Table once and putting it all into a Queue.
> So I did not care about behind, ahead or timeout. I just wanted to read
> as much as I could as fast as I could. For a browse you might want
> something quite different. Like Buffer(MyView,30,5,2,300)
I'm the director of Information Systems for a large company. We are a 100%
Microsoft/SQL Server shop. I can assure you that Microsoft's Index Tuning
Wizard is one of the real software gems you want to make use of. We recently
used it to trim the runtime of a large customer matching job from 8 hours
down to 57 minutes! The success you have with this tool is often
remarkable. Happy to hear your BUFFER statement worked for you. However,
never overlook the usefulness of the Index Tuning Wizard. The results are
sometimes unbelievable.
Ralph Tartaglia
Today is November 21, 2024, 6:43 am This article has been viewed 35464 times. Google search has resulted in 675 hits on this article since January 25, 2004.
|
|