Solved

Subsequent starting and stopping dbsrv gives better performance

Posted on 2003-11-28
3
304 Views
Last Modified: 2012-08-13
I have a situation where some queries have a poor performance. (ASA6)
I discovered that if I start and stop the database 5 times, the performance is very good.
This trick does not work with two times, no, 5 times is needed to get the good performance.

How can this be explained?
0
Comment
Question by:jvv
3 Comments
 
LVL 6

Accepted Solution

by:
DaniPro earned 250 total points
Comment Utility
This is a strange situation, I'm suggesting you of verify the plan of your query when the database start for frist time and when the database start for tifth time.
After you can try to drop the database statistics [ DROP OPTIMIZER STATISTICS ].

Occasionally, the statistics may become inaccurate or relevant statistics may be unavailable. This condition is most likely to arise when few queries have been executed since a large amount of data was added, updated, or deleted.

In this situation, the best approach is to execute statements that allow Adaptive Server Anywhere to scan the new rows sequentially. The internal statistics are automatically updated as a side effect, allowing the optimizer to choose better plans for subsequent queries.

The DROP OPTIMIZER STATISTICS statement deletes all internal statistical data from the column statistics registry. This drastic step leaves the optimizer with no access to essential statistical information. Without these statistics, the optimizer may generate very inefficient data access plans, causing poor database performance.

This statement should be used only during problem determination or when reloading data into a database that differs substantially from the original data.


0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SyBase SQL Syntax 7 309
dbisql 5 548
InterSystems Caché OPEN QUERY 4 415
Call sybase stored procedure from php 8 41
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now