Re: Help! Server Tuning/speed/optimization
Date: 1997/09/06
Message-ID: <01bcbac6$d8a4c820$381bf8ce_at_st-pierre95>#1/1
For a full Interactive Internet Quick Tour about SQL-Optimizer/DBA check: http://www.sfi-software.com/qt/sqloptimizerdba10/qtinternet.htm
For details, http://www.sfi-software.com or call SFI at (USA) 617 722-9811,
Canada 819 778-5045 or email to:
info_at_sfi-software.com
Sam,
SFI is a Sylvain Faust company, since 1988
http://www.sfi-software.com
Sylvain Faust Inc. (SFI) was founded in 1988 by experienced database programmers intent on improving programmer productivity by developing a suite of tools, utilities and knowledgeware designed by programmers, for programmers. Productivity enhancement software in this market can easily pay for itself in a matter of days just in labor savings, not to mention the competitive advantage gained by organizations able to deploy information systems faster and more reliably. SFI's current products include SQL-Programmer, SQL-Optimizer and SQL-Sombrero.
Saunnie McGee <saunnie_at_gcr1.com> wrote in article
<01bcb7be$423d15a0$724c1bcc_at_Saunnie.gcr1.com>...
> Does anyone know of some simple strategies for optimizing a database?
>
> Queries that return under 1000 records take about 1 minute. In user time
> that's way too long. We have an average of 20,000 records in the tables
we
> are testing. We are using a Developer 2000 (forms 4.5) front end and the
> database is version 7.3.2.2.1.
>
> saunnie_at_gcr1.com
>
Received on Sat Sep 06 1997 - 00:00:00 CEST