<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>
myOffice Email Message
</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="date" content="2002-11-01">
<style type="text/css">
</style>
</head>
<body>
<span style=
"color:#FF0000 "><b><span style=
"font-family:MS Sans Serif ">[Reply]</span></b></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">HI all,</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">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.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Is this due to (a) this is not something that is straight forward ( ie fish hooks abound), or (b) this is not something Delphi developers really want to do ( they prefer other DB's ), or (c) are people keeping their solutions close to their chest?</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Are the component sets included in Delphi up to the job?</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Are there other third party components that do a better job for the simple Data Aware architecture?</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">In John's case it may well be the VM has limited resources - it's all on his laptop with 2M total, and Vista as the host may well be hogging memory etc.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Ideas, opinions appreciated.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">cheers</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Gary</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">A</span><span style=
"color:#FF0000 "><b>t 00:40 on 20/01/2010 you wrote </b></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>To : delphi@delphi.org.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>CC : </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>From: John Bird, johnkbird@paradise.net.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Content Type: text/html</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Attached: </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>This is a multi-part message in MIME format.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>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.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>The slowness was the main reason I wanted to check DBExpress or simpledataset to see how fast they were.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Since then we decided to put an initial filter in the select SQL, and the time taken to return data is definitely proportional to the number of records - 30 records takes under a second, 700 2-3 seconds. This is workable, although want faster.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Question 1 - might the VMWare need tuning? With XP, MSSQL, D2007, and a large dataset etc running may there some memory bottleneck issues with the VM? Has 512MB assigned for VM, looks to be sufficient..</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>One trick I have read is to disconnect any datasource and/or controls while data loads - this can make a huge difference when loading a large dataset. (This was in the help for TKBMMemtable).</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Question 2 - How does ADO compare in speed to BDE/DBX etc?</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>John</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> 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, point it at your server, and then get your application to hit the server and see where the bottleneck is. DBOptimizer can also show you network issues if it's that, and can also highlight if your client is spamming a slow down message while it tries to digest the resultset. The trial edition will give you all the results (it's evaluation time limited, not feature limited) </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Peter Joint</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Embarcadero Technologies, Inc. | www.embarcadero.com </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> peter.joint@embarcadero.com</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Office: +61 (3) 9018-7752 | Fax: +61 (2) 8296-5831 | Mobile: +61 (404) 646 486</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Linked in: http://www.linkedin.com/in/peterjoint</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> From: delphi-bounces@delphi.org.nz [mailto:delphi-bounces@delphi.org.nz] On Behalf Of Jeremy Coulter</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Sent: Tuesday, 19 January 2010 7:57 PM</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> To: 'NZ Borland Developers Group - Delphi List'</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Subject: Re: [DUG] MSSQL with D2007</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> OR.....your DB server is just really slow J</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> We use the TADO controls, but were possible, or where I am not being lazy, use non DB bound controls.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> 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.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> jeremy</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> From: delphi-bounces@delphi.org.nz [mailto:delphi-bounces@delphi.org.nz] On Behalf Of David Brennan</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Sent: Tuesday, 19 January 2010 21:19</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> To: 'NZ Borland Developers Group - Delphi List'</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Subject: Re: [DUG] MSSQL with D2007</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> 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.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> 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 attention to data transfer times be honest!)</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> David.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> From: delphi-bounces@delphi.org.nz [mailto:delphi-bounces@delphi.org.nz] On Behalf Of John Bird</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Sent: Tuesday, 19 January 2010 8:05 p.m.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> To: NZ Borland Developers Group - Delphi List</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Subject: [DUG] MSSQL with D2007</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Been trying to connect to MSSQL 2005 with DB Express (TSQLConnection and TSQLQuery), but cannot get it to work, we are getting an access violation at address 017E0913 in DBXMSS30.DLL read of address 01820000</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Using instead ADO (TADOConnection and TADOQuery) works fine, but is slow - 7000 records takes 30-40 seconds to load.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> The rest of the components the same (ie TDatasetProvider, TCLientDataSet, TDatasource) ie have been pointing the Datasetprovider at either the TADOQuery or the TSQLQuery</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Also tried the TSimpleDataSet, has the same error as the first sentence.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> All the queries allow me at design time to set active to true successfully, but still crash when the dataset is set to open....</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Does anyone have any idea what could be going wrong?</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> And any recommendations of best combinations you prefer for MSSQL with D2007. I am new to connecting D2007 to MSSQL so willing to do it whichever way works best.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> John</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>------------------------------------------------------------------------------</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> _______________________________________________</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> NZ Borland Developers Group - Delphi mailing list</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Post: delphi@delphi.org.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Admin: http://delphi.org.nz/mailman/listinfo/delphi</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">> Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>_______________________________________________</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>NZ Borland Developers Group - Delphi mailing list</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Post: delphi@delphi.org.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Admin: http://delphi.org.nz/mailman/listinfo/delphi</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe</span></span><p>
<font face=arial size = 1 color = Navy><font color=gray face = "helvetica,verdana,arial" size = 1><br /><br>
<font size=2 color="black">Gary Benner </font> MNZCS ITCP<hr /><br>
<a HREF="http://www.semantic.co.nz" style="text-decoration:none; color:blue">Semantic Limited</a> - Online Education, e-Commerce, Software Development & Systems Design<br /><br>
<a HREF="http://www.123.net.nz" style="text-decoration:none; color:blue">123 Internet Limited</a> - Managed Web Hosting, Virtualisation, High Availability Systems & Cluster Technologies<br /><br>
<b>Mob:</b> 021 966 992<br /><br>
<b>DDI:</b> +64 7 543 1206<br /><br>
<b>Email:</b> <a href="mailto:gary@benner.co.nz" >gary@benner.co.nz</a><br /><br>
<b>Skype:</b> garybenner<br /><br>
</font><br>
<br>
Ref#: 41006<br>
<br>
</body>
</html>