Testimonials
 |
SSW Performance PRO! enabled our company to increase performance and productivity. Thanks SSW team for a great product! |
 |
-
A Mavrogeorgis, Mavrogeorgis Holdings Pty Ltd
Awards
SSW Performance PRO! isolates performance bottle-necks in your Access 97, 2000, 2002 or 2003 app. It checks every form, combo and list box,
and reviews SQL statements. It reports exactly what to fix to improve the the speed of your application. SSW Performance PRO! is
especially useful after you've upsized an application to SQL Server to pinpoint black spots in your app.
SSW Performance PRO! evaluates the speed of your forms so you can work where it will
make a difference. It
works whether your backend is Access (mdb) or Microsoft SQL Server. It
works whether you have a single/multiple backend(s). It also works for
Access Data Projects (adp).
This cool utility analyzes every form, every combo and list box, checks the SQL
statements and works out the time of executing these SQL statements -
obviously you will get the best results if your Access database is linked
to server across the network. After you use the generated reports, you
can optimize design of your forms and controls without any worries.
You know you shouldn't have large record sets in your database... Microsoft Access
developers too often use forms and combos bound to large tables or slow
queries. Let this wizard analyze your front end database and tell you
what forms are slow and what controls are the culprits in each form. Now
use your development time on the things that really matter. Then re-analyze
and see your progress.
Key Features & Benefits
SSW Performance PRO! analyzes the performance of your Microsoft Access database. It
is a great tool if you're about to upsize your database from Access to
SQL Server.
Note: You must have a client/server application where the front end database has tables
linked to an Access or SQL Server back end database.
Note: BEFORE running SSW Performance PRO! check:
-
macro Autoexec should be renamed to _Autoexec
-
'User and Group Permissions' for the table MSysObjects should be set to 'Administer'.
Here are some of the intuitive interfaces of SSW Performance PRO!
You can select one of two options:
-
analyze
all forms
- analyze
one form
Forms are
selected in random order which provides correct time estimates. You can
also change the number of loops used to execute the SQL statement. It
averages results and provides better approximation.
Note:
If you are using an unregistered version of SSW Performance PRO! only
70 percent of all forms are processed and the 'One form' option is disabled.
The first
report - 'SSW Performance PRO! - Summary' gives summary information
about the slowest forms in your front end database
The last report
gives you detailed information about the slowest forms and controls on
that form including RecordSource (for a form) or ControlSource (for a
control).
From
this information, you can determine the best place to start optimising
your application.
More screen shots in the User Guide.
Reports
Here are the SSW Performance PRO! Summary and Detailed reports for the Sample northwind database included
with SSW Performance PRO! You will need the Microsoft Access Snapshot Viewer to view these links.
Download it here
System Requirements
What does the unregistered version give me?
In respect to the unregistered version we know you want to see it
working before you buy it. We aim for that.
Note: we also give free version targeted to the little guys
More details see http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q658302
SSW provides free phone and email support to answer queries on
registered products.
Getting Support
If you can't find it in the product documentation then check our knowledge
base for further information and tips about this product.
Please send us bug reports and feedback
so that we can evolve our software into a product that matches your requirements. We guarantee a response.
Links
What
utilities and updates should I get for my PC?
This is one of the frequently asked questions by SSW clients, so we have
compiled a list.
Waring
SSW Performance PRO 2000 supports only Access 2002/2003/2007.
I'm Sold... What's next?
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.