I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons neither how to solve this problem.

i'm working on 64 bit machine with 2 CPU's Xeon 3.4 GHz and 2 Gb of RAM.

the database contains 20 feature class, but with the max number of features do not exceed 100 000 in some feature classes, if i wait to view the data i should wait 10 minutes.

i tried to compress and rebuild indexes in the database using the above scipt but there's no improvements at all.

import arcpy , sys , os
arcpy.env.overwriteOutput = True


db_name  = sys.argv[1]

db_path = os.path.join(os.path.dirname(__file__), "Connection_"+db_name+".sde")
arcpy.env.workspace = db_path

#disconnect all users from the database.
arcpy.DisconnectUser(db_path, "ALL")

# Get a list of versions to pass into the ReconcileVersions tool.
versionList = arcpy.ListVersions(db_path)


# Execute the ReconcileVersions tool.
arcpy.ReconcileVersions_management(db_path, "ALL_VERSIONS", "sde.DEFAULT", versionList, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "DELETE_VERSION", "c:/reconcilelog.txt")

# Run the compress tool.
arcpy.Compress_management(db_path)

#Allow the database to begin accepting connections again
arcpy.AcceptConnections(db_path, True)

dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters()

# Next, for feature datasets get all of the featureclasses
# from the list and add them to the master list.
for dataset in arcpy.ListDatasets():
    dataList += arcpy.ListFeatureClasses(feature_dataset=dataset)


##print dataList
# pass in the list of datasets owned by the admin to the rebuild indexes and analyze datasets tools
# Note: to use the "SYSTEM" option the user must be an administrator.
arcpy.RebuildIndexes_management(db_path, "SYSTEM", dataList, "ALL")

arcpy.AnalyzeDatasets_management(db_path, "SYSTEM", dataList, "ANALYZE_BASE", "ANALYZE_DELTA", "ANALYZE_ARCHIVE")

i tried to view data from ArcMap, i have founded the same problem.

Using the performance monitor i remarked some bottlenecks in CPU and network sides.

I'm available for explanations of the problem.

Any help please.