Solved

bde / query / network performance

Posted on 1998-08-21
3
184 Views
Last Modified: 2010-04-04
I am working with delphi 1, and i heve made a application which uses
paradox tables on a server. When i launch a query the network has a load
off more then 90% . When more users do this , then the normal
updatscreen gives an error and the result is damaged indexes.
do you know a solution??

thanks a lot,

Lambert Venema , Holland.
0
Comment
Question by:lambertvenema
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Expert Comment

by:EmmDieh
ID: 1337436
This seems to be typical for a file based database.
They only support a handful of users and paradox seems
to suffer from frequent index corruptions.

I would use a client-/server database like InterBase.

0
 
LVL 5

Expert Comment

by:mayhew
ID: 1337437
Also, are you using TTable or TQuery components?

TTable's can really increase overhead.

Don
0
 
LVL 1

Accepted Solution

by:
jcasteel earned 100 total points
ID: 1337438
File base database systems are not the best way to do it.

There are a few items that will increase the load on your network.

1. Use TQuery instead of TTable.
2. Prepare your statements before executing them.
   if you do not prepare the TQuery object, Delphi itself will prepare it each time when it is executed.
3. If you have a few of lookup table with towns that have a limited number of items -> read them in memory with linked lists so you can access them without going to the database each time.
4. Try to group transactions instead of commiting each little transaction.  TDatabase object - > StartTransaction and Commit;
 this means that a user will make several transactions ( inserts / updates / deletes ) before commiting the data.

I am not user if the following was already applicable in Delphi 1 maybe it is from Delphi 2
5. Put RequistLive false and use TUpdateSQL to make your changes

6. Try to limit the number of data  that is being retrieved by the user. If a table contains 100000 records, use TQuery with a where clause so only the relevant records are being retrieved.
Nobody is interested in 100000 records.

Thas what I did for my tuning of the application,

Have fun

Jan Casteels
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

737 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