 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
xkorakidis
Guest
|
 Posted: Wed Nov 01, 2006 3:41 pm Post subject: Application performance |
 |
|
Hi, I developed an application in Delphi 7 & Interbase and when I filled
tables with data (2500 recs max) the application was too slow! I tried to
debug application and followed each step (F7). Although some functions (e.g.
ibdataset.insert, ibdataset.open) lasted 1-2 seconds, when I run the final
(.exe) application, it is much more slower. Does there exist any interesting
testing tool so as to find what goes wrong with the performance of the application?
Sory for my English 
Thanks! |
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Thu Nov 02, 2006 2:17 am Post subject: Re: Application performance |
|
|
If executing SQL statements is slow download IBPlanalyzer (you can find
it with Google), read the help file and follow the instructions. If you
need addtional help with database performance post a message in the
interbase.general newsgroup and tell us exactly what is slow.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
xkorakidis
Guest
|
| Posted: Sat Nov 04, 2006 2:57 am Post subject: Re: Application performance |
|
|
Hello Bill,
I think that is an architecture/design problem...
I'm working mainly with ibdataset and in some datasets I added lookup fields
(orders->customers-roads,municipalities). The combination of all tables makes
things worse. I made some changes and things have been improoved. When I
need customer's data for lookup purposes (new order) I don't touch customers'
dataset but I get only the customer I need with an IBQuery. This change has
improved the performance of application.
Furthermore, I was looking for an application optimizing tool, in order to
check what routine needs much time, what transaction has not been closed
intime, etc. so as to improove the quality of written code. I have heard
in past for such tools but I don't remember any...
| Quote: | If executing SQL statements is slow download IBPlanalyzer (you can
find it with Google), read the help file and follow the instructions.
If you need addtional help with database performance post a message in
the interbase.general newsgroup and tell us exactly what is slow.
|
|
|
| Back to top |
|
|
Andrew
Guest
|
| Posted: Sat Nov 04, 2006 9:11 am Post subject: Re: Application performance |
|
|
"xkorakidis" <xkorakidis (AT) yahoo (DOT) gr> wrote in message news:5b70eef20dcf8c8cde4e0c533d4 (AT) newsgroups (DOT) borland.com...
<snip>
| Quote: | Furthermore, I was looking for an application optimizing tool, in order to
check what routine needs much time, what transaction has not been closed
intime, etc. so as to improove the quality of written code. I have heard
in past for such tools but I don't remember any...
If executing SQL statements is slow download IBPlanalyzer (you can
find it with Google), read the help file and follow the instructions.
If you need addtional help with database performance post a message in
the interbase.general newsgroup and tell us exactly what is slow.
|
Try AQTime for general profiling and optimizing - I can't do without it.
Andrew |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
