Hi guys,
I've written an application which does an xsl transformation (into a
memory stream) to generate a load of sql insert statements. I then
loop through this, and execute the sql (into Access). (I'm using .Net
v1.1)
The transformation is quite slow, but I'm not too bothered about that
(I've read it'll be much faster in .Net V2.0). When the application is
doing the insert statements, it uses 100% of the cpu (as expected), and
inserts about 200 records/second. If I open Microsoft Access, it grabs
all the cpu time (as Access does), but when I close it, the system idle
process has all the CPU time rather than my C# app. Has anyone else
seen anything similar, is there anything I can do to grab all the
resource back for my application? After I've closed Access, my
application runs much, much slower.
I've looked at setting the priority of my process to "High" in c#, but
doing this manually in Task Manager doesn't seem to make any
difference.
Any ideas would be much appreciated.
Thanks in advance
Ryan 3 1341
I probably should have said that this only seems to happen if I open
the same database in Access which I'm also inserting into from C#.
Ryan ry************@norubbishgmail.com wrote:
Hi guys,
I've written an application which does an xsl transformation (into a
memory stream) to generate a load of sql insert statements. I then
loop through this, and execute the sql (into Access). (I'm using .Net
v1.1)
The transformation is quite slow, but I'm not too bothered about that
(I've read it'll be much faster in .Net V2.0). When the application is
doing the insert statements, it uses 100% of the cpu (as expected), and
inserts about 200 records/second. If I open Microsoft Access, it grabs
all the cpu time (as Access does), but when I close it, the system idle
process has all the CPU time rather than my C# app. Has anyone else
seen anything similar, is there anything I can do to grab all the
resource back for my application? After I've closed Access, my
application runs much, much slower.
I've looked at setting the priority of my process to "High" in c#, but
doing this manually in Task Manager doesn't seem to make any
difference.
Any ideas would be much appreciated.
Thanks in advance
Ryan
First - I can't comment on the Access side - not my thing - and this is
probably the main part of your post.
However : xslt. Yes it can be quicker in 2.0, but it isn't a magic bullet.
If your transform is running slowly it is probably due to a non-optimal
design rather than the raw engine speed. Common foobars:
* not using xsl-indexing (and Munchean grouping in particular)
* [ab]use of //SomeNode (the // being the issue)
* [ab]use of open axes such as descendant::, preceding:: or following::
Marc
Ok, thanks for the advice. I'm fairly new to xsl, so I'm sure there
are loads of things I'm not doing properly! When I've got a bit more
time I'll do some reading about it, and try and speed things up.
You are correct, the real issue at the moment is with Access.
Thanks
Ryan
Marc Gravell wrote:
First - I can't comment on the Access side - not my thing - and this is
probably the main part of your post.
However : xslt. Yes it can be quicker in 2.0, but it isn't a magic bullet.
If your transform is running slowly it is probably due to a non-optimal
design rather than the raw engine speed. Common foobars:
* not using xsl-indexing (and Munchean grouping in particular)
* [ab]use of //SomeNode (the // being the issue)
* [ab]use of open axes such as descendant::, preceding:: or following::
Marc
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: monu agrawal |
last post by:
Is there any way in pgsql to measure that how much time a transaction has taken & how many disk accesses it has performed.
#############################################
# Monu Agrawal #...
|
by: Bob Alston |
last post by:
Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users. So far I haven't
had performance issues to worry about. <knock on wood>
...
|
by: Mark Shelor |
last post by:
I've encountered a troublesome inconsistency in the C-language Perl
extension I've written for CPAN (Digest::SHA). The problem involves the
use of a static array within a performance-critical...
|
by: 1944USA |
last post by:
I am re-architecting a C# application written as a multithreaded
Windows Service and trying to squeeze every bit of performance out of
it.
1) Does the thread that an object is instantiated on...
|
by: Demetri |
last post by:
I have a question / concern regarding the new suggested way of creating a
data access layer in an n-tier application. Typically, a web application
specifically, using the SOA (Service Oriented...
|
by: roadrunner |
last post by:
Hi,
Our website has recently been experiencing some problems under load. We have
pinpointed a particular function which slows dramatically when we have these
problems. Normally it should execute...
|
by: Lloyd Dupont |
last post by:
I have an application which use has a DLL with 100+ (auto-generated) Managed
C++ wrapper around some native API.
Compare to a purely version my application has some performance issue and I
just...
|
by: Bob Alston |
last post by:
I have recently been trying to determine the best technique to pull the
least amount of info across the LAN link in a slow speed LAN situation
(e.g. < 10 Mbps), where data volume = performance.
...
|
by: gg |
last post by:
I specify the Url element as
<xsd:element name="Url">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="512"/>
<xsd:pattern value="http://+"/>
</xsd:restriction>...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |