DBExpress terrible performance when migrating from Delphi 7 to Delphi 2007
When I'm migrating my project from Delphi 7 to Delphi 2007, I found that the speed slow down 3-4 times. I've started to investigate what is the reason of that and I've found that the problem is in the TSQLDataset component. So I make a simple example of an application that run one of my problem queries that fetches about 30000 rows and the result was amazing d7: 1500ms, d2007: 13500ms 8 times slower !!!!
Here are some perameters of the TSQLConnection
object SQLConn: TSQLConnection
ConnectionName = 'OracleConnection'
DriverName = '...Poor Performance using TSA Test and overall NSS performance.
This is a local test on a RAID 1E system with 12 SCSI Ultra320 146GB@10K
SMS - TSA Statistical Analyzer
Backing Up :DATA2:
Read Count: 13266 Min. Read Time: 000us
Last Read Size: 65536 Last Read Time: 2400us
Total Bytes Read: 629512878 Max. Read Time: 305500us
Raw Data MB/min: 424.14 Avg. Read Time: 6400us
Backup Sets: 3950 Avg. Scan Time: 400us
Avg. Open Time: 000us Total Read Time: 85s
Avg. Close Tim...recursion and memory use... a lot of memory use.
I have this program that recurses through a directory structure building
Default.htm files. The idea here was to quickly generate a bunch of these
things to replace the default index listing you normally see. The part
that's giving me trouble is the navbar that should have a nested structure
So that if you are in /DocRoot/Food/Fruit you would see the above on the
left all properly linked yada yada. The code I've pasted in does this just
fine (I've removed a b...To use or not to use Delphi
Sadly, it seems to me that there is a sort of race between the two threads, for and against using Delphi in new projects, with more or less the same users posting in both threads. Arguments are fiercely debated in both camps.
Borland had their own vision. As a community, now that Delphi has changed ownership I believe we should try to be more consistent, more clear, and more articulate in what we expect from Embercadero in terms of Delphi. We can contribute to keeping Delphi alive and moving in the right direction.
"Laurent Cocea" schrieb:
> Sadly, it seems to me that there ...Newbie: ClientDataSet, just as memory table
I want to use a ClientDataSet as a memory/local table, not connected to any Provider. I specified a FileName where to write its contents, yet when running the app, I get a run time error, asking for a Provider. Am I missing something?
Guillermo Najar wrote:
> I want to use a ClientDataSet as a memory/local table, not connected
> to any Provider. I specified a FileName where to write its contents,
> yet when running the app, I get a run time error, asking for a
> Provider. Am I missing something?
You should create all TFields, and instead of call Clien...Poor performance using accounting software
I have an accounting package that uses Pervasive 2000 on a Netware 6.5SP2
server. The hardware is a Dell PE2650 dual-1.8GHz w/1 GB RAM and a
RAID-10 18 GB array using the PERC 2 controller. I moved the accounting
system from a Netware 4.11 server which ran on a PIII-550. I'm also using
Now, processes that ran 30 minutes on the old server can take up to 6 hours
on the new. I have reviewed performance tuning settings and cannot see what
could be wrong. The software vendor (Oil and Gas Information Systems in
Fort Worth) can only give general networking suggestions, but n...Delphi 2007 massive memory use
I have a source file with about 40,000 lines in it. Every time I hit a key stroke BDS.exe's memory use goes up by about 12 MB! I have to exit and re-start Delphi every few minutes or it runs out of memory at about 1GB and dies.
Is there any solution to this please?
Based on my own recent *repeated* experiences... you may be creating a
variable within a procedure
and then not freeing it afterwards when no longer needed.
There are probably many better ways, but what I do is put a visible field on
my form and call this within
whatever main loops you have, then watch the changes ...bad performance using temporary tables
I�ve got a really misterious problem:
A common technique to pass "array-like" parameters
to a stored proc is to create a temporary table, fill this
table and call the stored proc (which expects this table
to exist during run time) doing something with the given
I use this method very often - until I discovered the
following: As most of you know, the name "#temptab"
isn�t exactly the name of the table, but instead the
server adds a postfix to the name - depending on
the process (user, session) which created the table; so
if you us...Poor performance using wireless broadband
My environment: Windows XP SP2, Novell Client for Windows 4.91 SP2,
wireless broadband showing 3Mbps in Task manager, on Lenovo(IBM)
When using internet, Lotus Notes, various other applications and
transferring files, performance over wireless broadband is fast enough
and, more or less, as expected.
When I log into Novell, performance is disappointing. In particular,
Windows explorer (which has network drives mapped) performs very slowly
when traversing directories - task manager is indicating less than
dialup speeds. My network support people say this is because of all...Poor query performance when using parameters
I have a Group By query which runs well when using a criterium without
parameter values. It takes less then 2 seconds to execute.
However, when using parameters, it takes over 20 seconds to execute the
Is there a way to 'tune-up' the performance while using parameters?
Index On DateTime
Index On MessageClass,MessageNumber
About 1,000,000 records
DECLARE @DateTimeFrom CHAR...Delphi 2010 - dbexpress
I use the dbx driver for firebird named dbxfb.dll and in my application i do a select every seconds. the memory of the process increase every 30 minutes but when i use Fastmm to check the memory leaks : no memory leak.
I have noticed that if i do not do the open and close primitive, no more memory leak !!
Here is my source
LQuery := TSQLQuery.Create(Self);
LQuery.SQLConnection := SQLConnection;
LQuery.CommandText := 'SELECT * FROM '+ TableName + ' where EventId = :EventId';
LQuery.ParamByName('EventId').AsInteger := EventId;
LResult...Memory used up by a datset with one table in it?
I have a single table in a dataset that I create in my code. This table is also created in my code. The table is made up of 1000 records with 1500 bytes/record. HOW MUCH MEMORY WILL BE TAKEN UP BY SUCH A DATASET? I know that this memory is not going to be 1000 X 1500 = 1.5 MB.
I would recommend strongly against keeping a (minimum) 1.5 MB DataSet in RAM. Datasets have a reasonably high amount of overhead. What would you be doing with the Dataset? Can you just do your searching and sorting on the database and get smaller datasets when required?Starting with ASP.NET 2.0? Look at...Memory Leak when using Proxy tables.
I'm using 6.02.2371 on WINNT-4.0 SP6. On a single server I have two database
servers running, Databse-1 uses page size as 2048 and the other Database-2 uses
page size as 4096. Database-2 has proxy tables which read data from database-1.
Bith databases are working fine, problem comes when Database-2 tries to
access/query lot of data throgh proxy tables, there is memory leak, and
eventually whole memory is used up. Then we have to stop and start the
database-2 and it comes back to its original memory use.
Thanks for your help,
---== Posted via the PFCGuide We...Poor Performance with Small Table References
I have noticed something odd. I have a small table containing tax
rates, It contains:
Description - char(30)
Rate - float
Code - char(8)
The code is the primary key, and the table currently has three records
If I issue a "SELECT * FROM Tax" within ISQL then I get an immediate
response. However, if I issue a "SELECT * FROM Tax ORDER BY Code" then
I get the first two records, an 8 second delay, then the remaining
record. This is the same effect that I get when I run something
similar from code.
After some investigation, I've found that the tab...