Discussion Locked

Connection Speed is slow!!??

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have developed powerbuilder App. that connects to a database on a Sybase server running on an NT server ,
My database file is 50 MB in size & rapidly growing, and the connection & data retrievl is getting slower.

I need to know the proper configuration when running the dbServer.exe (some parameters used in the connection path of the dbserver file) on the NT server & when running the client's connected to (.db) database through ODBC assuming TCPIP is the network protocol used.

I highly appreciate your suggests.

5 replies

by cfburgess

Move an absolute minimum of data from dbengine to clients. Make sure that the results sets are being generated by the server. Build views, use server side cursors, stored procedures, etc. The data engine is optimized for parsing/searching data, make sure it is doing the work.
Seems as though there is a help file in the Sybase dir that discusses startup parameters on the engine.

by donq

If your Sybase "back-end" isn't "NORMALIZED" and every Table indexed to support the procedures you are running your problems are just beginning. You failed to mention anything regarding your warehouse structure however if you can get results slowlyyou are already connected! 50MB is nothing for a properly modeled mainframe (or server)database product (like Sybase, DB2, Oracle, Informix, or SQL-Server).

Sorry my answer doesn't help but I think your problems may lie elsewhere?

This discussion is closed to new replies.