[AccessD] DBA web site update

Hi Jürgen:

Any help would be greatly appreciated.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jürgen Welz
Sent: February 7, 2006 12:13 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] DBA web site update

I'll have to generalize my routine a bit.  It is essentially a class module 
without being a class module(properties & method and a call that sets and 
initializes properties such as sort column and direction (so as not to have 
to pass them in with recursive calls used by a quick sort algorithm) and it 
may erase upon exit with the final return from recursion, depending on the 
purpose.  The more generic VB6 version I used also runs in Access but I have

that at home on a USB drive.  Perhaps setting it up as a class module that 
will accept recordsets and arrays will be the better solution.  I'll have a 
closer look this evening as I'm taking some safety supervisor training 
today.


Ciao
J|rgen Welz
Edmonton, Alberta
jwelz at hotmail.com


>From: Jim Lawrence <accessd at shaw.ca>
>
>Hi J|rgen:
>
>That article is a fine demonstration how technique and method can
>dramatically enhance performance. Would you be able to send a code sample 
>so
>that it would be able to be added into the DBA article on Array 
>performance?
>The speed will not be able to surpass C++ but it might be able to close the
>speed gap between C# and VB.Net.(?)
>
>If methods like Quick or Lightning sort were implemented with this 
>technique
>would there be yet again any sort speed increase?
>
>Jim
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JC<rgen Welz
>Sent: February 7, 2006 5:46 AM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] DBA web site update
>
>I've been able to implement the concepts discussed at the link:
>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/h
t
>ml/LightningStrings.asp
>
>for sorting two dimensional string arrays as this approach only requires 
>the
>
>use of available libraries.
>
>Ciao
>J|rgen Welz
>Edmonton, Alberta
>jwelz at hotmail.com
>
>
>
>
>
> >From: Jim Lawrence <accessd at shaw.ca>
> >
> >Hi All:
> >
> >A new article, 'Array Performance', as well as some minor changes has 
>been
> >added to the DBA web site (www.ddatabaseadvisors.com).
> >
> >Jim
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com