We use TAdoConnection and TAdoStoredProc to retrieve and save data to/from
the database and it works fine. We use ClientDatasets for editing the
database at the front end though (ie we populate from TAdoStoredProc, the
user edits the client dataset, then we put back via TAdoStoredProcs).
I should say there is something wrong with your ADO setup if it is taking
that long for 7000 records, unless they are VERY big records.
7000 records of 2-4000 bytes each should be only a second or so (don't want
to be more accurate in my estimate without testing, been a while since I
paid much
It would also help to know where the database is in relation to the actual
client. Are you on a gigabit network, 100mbit, or a VPN running over the
internet. all these things can play a role.
I am using the SDAC component suite.. Fast, Reliable. no issues so far.
On Tue, Jan 19, 2010 at 9:19 PM,
OR.your DB server is just really slow J
We use the TADO controls, but were possible, or where I am not being lazy,
use non DB bound controls.
However I have heard the SDAC controls are meant to be pretty good as Kyley
seems to back up. Just a bit expensive from Memory.
jeremy
From:
I'd be looking to make sure that the DB Server itself isn't the bottleneck here
- quick and easy test, run the SQL select statement through Query Analyser
(yuck!) and see what sort of response time you get. Alternatively, (and
shameless plug) download a copy of DBOptimizer from our website,
The DB server is as local as can be - ie in this case its on the same PC -
although in a VMWare workstation virtual PC.
The slowness was the main reason I wanted to check DBExpress or simpledataset
to see how fast they were.
Since then we decided to put an initial filter in the select SQL, and
John
If ADO is slow check the type of dataset that it is opening, it may be a
dynamic cursor where as for TCLientDataSet you onlu need a quick pass
thru, remember ADO has its own client data management built in
HTH
Neven
Been trying to connect to MSSQL 2005 with DB Express (TSQLConnection
Version is 3.5.7. Processor usage is sporadic. Currently is using 5% - 40%
but mostly around 10%. I can't see any flash going on.
Regards
Sean Cross
CIO
Catalyst Risk Management
PO Box 230
Napier 4140
DDI: 06-8340362
Mobile: 021270 3466
Visit us at
+1 on sdac http://www.devart.com/sdac/
Regards
Sean Cross
CIO
Catalyst Risk Management
PO Box 230
Napier 4140
DDI: 06-8340362
Mobile: 021270 3466
Visit us at http://www.catalystrisk.co.nzhttp://www.catalystrisk.co.nz/
Offices in Auckland, Hamilton, Napier, Wellington, Christchurch Dunedin
How big are your rows? Still sounds painfully slow to me unless there are
decent sized blobs in each row.
Neven has a good point about cursor type too although I'm not sure any of
the options should be that slow. I could do some proper benchmarking if you
wanted but I know we definitely load
[Reply]
HI all,
In working with John on this one I did some research on available resources for
this task, and there seems to be a deafening lack of material available online.
As opposed to other Delphi related topics.
Is this due to (a) this is not something that is straight forward ( ie
Sorry.. I forgot to add that the Disk issue was with TEMBDB growing to over
1gb.. and the VMware disk is limited in size. the Ram issue is when SQL
server sucked up all the ram and VMware only was allocated 2gb. Tembdb was
normally the issue though.
On Wed, Jan 20, 2010 at 9:58 AM, Kyley Harris
I'm sorry but I disagree. If all of those tabs are loaded then it
shouldn't be using any CPU, or a very small amount.
Firefox has security issues, just like IE.
I use both but prefer IE, it handles flash a lot better than Firefox.
Couldn't get into Chrome.
I installed Firefox on the mac but it
Hi,
I have a report from a Windows 7 user that a message from my app does not
show unless XP compatibility mode is selected.
The code that should fire is:
messagedlg(msg, mtCustom, [mbOk], 0);
It is being ignored when run under normal Windows 7 default mode.
Any ideas?
I don't use
Are you sure that it is the message display that is being suppressed and not
some change in the runtime conditions that lead to your application even
attempting to display the message in the first place?
e.g. (a completely made up example) :
If ForceDirectories( ' .. path to some folder in
A longshot but are you calling MessageDlg prior to calling
application.run in the dpr?
Cameron Hart Development Manager
Flow Software Limited
PO Box 305-237, Triton Plaza
P
+64 9 476 3579
Auckland 0757, New Zealand
M
+64 21 222 3569
In Chrome you can find out what is using CPU for each tab, there is a task
manager.
Try the Firefox 3.6 beta
I really really would hesitate to use IE at the moment, seeing as all
versions including IE8 on Windows 7 are vulnerable to the latest China
exploit - while it affects IE6 on XP most
while it affects IE6 on XP most no versions are immune.
Scaremongering much John?
On Wed, Jan 20, 2010 at 10:20 AM, John Bird johnkb...@paradise.net.nz wrote:
In Chrome you can find out what is using CPU for each tab, there is a task
manager.
Try the Firefox 3.6 beta
I really really would
OK, let's say IE is more insecure than FF
Edward Koryagin
--- On Wed, 20/1/10, Jeremy North jeremy.no...@gmail.com wrote:
From: Jeremy North jeremy.no...@gmail.com
Subject: Re: [DUG] Offtopic - but.
To: NZ Borland Developers Group - Delphi List del...@delphi.org..nz
Received:
Scaremongering? Here is the Microsoft advisory link
http://www.microsoft.com/technet/security/advisory/979352.mspx
Some excerpts:
Our investigation so far has shown that Internet Explorer 5.01 Service Pack
4 on Microsoft Windows 2000 Service Pack 4 is not affected, and that
Internet
Think we solved this - its not memory - 1GB memory on the VM made no difference.
It is the size of the records being got - over 100 fields and 4000 + bytes per
record.
If we ask for fewer fields its not surprisingly an awful lot faster.
In others experience ADO is comparable in speed to other
100 fields.. That must be one mean table :)
On Wed, Jan 20, 2010 at 2:25 PM, John Bird johnkb...@paradise.net.nzwrote:
Think we solved this - its not memory - 1GB memory on the VM made no
difference.
It is the size of the records being got - over 100 fields and 4000 + bytes
per record.
I ended up installing Delphi, all components, database and the project on a
new Win 7 pc provided by the customer.
Tracing using the debug vcl units showed that the calls to messagedlg and
below were fine - just not showing the dialog!
Just for the hell of it I threw in an
Hi folks
I had a spare 10 minutes and summarised the 23 replies from everybody:
1. Still maintaining Delphi code?
No 0x
Yes 23x
2. Started a new Delphi project in the last year?
No 10x
Yes 13x
3. Started a new project in another
John
You can add Yes, No, PHP, C# to this list, it would appear I'm boring
Neven
Hi folks
I had a spare 10 minutes and summarised the 23 replies from everybody:
1.Still maintaining Delphi code?
No 0x
Yes 23x
2.Started a new Delphi project in the last year?
Gary/John
Firstly, Have you compared the 'load time' for the query from ADO versus
Query Analyser? If they are the same (QA is odbc based) then the perf
issue is Server/Query, if not then
its the ADO, check the ADODataSet (or equiv IIRC these are all wrappers
around tha ADO Command object) ,
Only 23 Delphi developers replied. I wonder how many people there are on
the
Indeed, the number of people that read the questions and couldn't even
summon sufficient interest to bother replying would be an interesting
statistic on its own.
___
NZ
If you need to check output/pages against the three main engines for
any reason - have a look at this:
http://www.lunascape.tv/
Lunascape is the world’s only triple engine browser. What this means
is that you can have the best features, performance, and speed of,
Windows Internet Explorer,
28 matches
Mail list logo