Re: [U2] [UV] Conversion code for week number

2007-07-17 Thread Mats Carlid
A final (?) note on year calculation shortcuts: Had Dick chosen jan 1 in a year divisible by 400 as day 1 then INT(DAY / 365.247525 ) would have worked all the time. But selecting a '400-year' starting on a sunday would result in quite long internal dates unless year 2000 started on a

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Anthony Youngman
Because the results are not (scientifically) reproducible. (Well, they are for that one implementation...) Because data storage is part of the Pick data model, we can be confident that benchmark results are valid across all (similar?) implementations. Because relational forbids knowing anything

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Nick Cipollina
On one hand, if the purpose of exposing this data is for internal consumption only, then some sort of proprietary format would be perfectly acceptable. In fact, we are using a sort of proprietary format for communication. The problem with this approach is that when you begin dealing with outside

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Geoffrey Mitchell
I don't have any idea what you are trying to say. A database should be a black box. You put data in and pull data out. The less you have to know about the details of what goes on inside, the better. You can easily benchmark two black box systems that perform the same function (with

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Mats Carlid
Anthony W. Youngman skrev: At which point, you hit my hobbyhorse ... In the real world ... - relational database theory has ABSOLUTELY NOTHING whatsoever to do with the real world. It's an exercise in pure maths. And You hit my hobbyhorse or rather one of them :-) ... RDMS theory is

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Jerry Banker
To me that is foolish. As a programmer you need to know how that database functions so you can program to its strengths and try to avoid its weaknesses. -Original Message- From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 17, 2007 9:58 AM To:

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Dawn Wolthuis
I do agree that it can help with benchmarks to lock into some givens and go from there, but even choosing something as common as SOAP gets you into the SOAP vs REST discussion (e.g. http://www.oreillynet.com/pub/wlg/3005). I can imagine doing benchmarks where you say given these technologies,

Re: [U2] system builder question(s)

2007-07-17 Thread Doug Chanco
thanks! Boydell, Stuart wrote: Doug, see the IBM website. U2/SB+ trial software: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial s Documentation including SBSolutions (Kevin King's book): http://www-306.ibm.com/software/data/u2/pubs/library/ 1. are there any

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Anthony Youngman
I understand your desire for a black box. The problem arises when your black box is upgraded. I've come across anecdotes of eg Oracle upgrades, where new software has resulted in a markedly slower system, because Oracle changed their data storage, or indexing, or something, and all the app's

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread phil walker
Nick, Here, here to your following statements To me, this is part of the problem that we have in the MV world. We look at how things are being done elsewhere and say, Pick does it better, we aren't going to do that. The problem with this approach is that everyone else is adopting these

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Nick Cipollina
This is one of the reasons that Cache is able to drum up some business from shops that are using Universe, UniData, etc... Cache is very forward thinking, and now with their mvbasic support, a viable option for those of us using MV databases and want to use newer technologies to integrate with

[U2] UV Command Stack

2007-07-17 Thread Jerry Banker
Someone was asking about the command stack, on Universe there is the @COMMAND.STACK variable that has a dynamic array of the last 99 commands. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread LeRoy Dreyfuss
These are interesting comments considering all the tools available with IBM U2 and the many things they have in the hopper. Regards, LeRoy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Wednesday, July 18, 2007 6:49 AM To:

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Dawn Wolthuis
On 7/17/07, Nick Cipollina [EMAIL PROTECTED] wrote: This is one of the reasons that Cache is able to drum up some business from shops that are using Universe, UniData, etc... Yes. I have been a loyal U2 professional for many years and thought I would end up selecting U2 for a new application.

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread phil walker
Leroy, I know IBM are implementing much of these new technologies with regard to U2. The problem that I see is that it may be there, but a lot of the people in the list cannot find information on how to use it either because this information * does not exist * exists but in very basic examples

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Don Kibbey
Interesting thread. Even though I don't really have much to do with UniVerse these days, I still enjoy reading (and learning from) these forums. I've been a long time user of both UniVerse and SQL Server. Developed many things using one, the other or both db's as data sources. I would say

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Nick Cipollina
--Not quite so easy to go .net - UniVerse. Well put. This is one of the issues we are running into. We are a .Net shop, and going from .Net to UV has been a challenge to say the least. The primary issue being the overhead associated with access the data via uo.net. Performance just isn't good

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Bill Haskett
Phil: A quick example is I'm trying to find out how their Connection Pool license works. Noone seems to know nor can I find out how this integrates with mv.Net using UO.NET as the connection. I can't find out how to configure a connection pool, monitor the connections, or anything else.

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Wally Terhune
Enroll for one of the U2 University events? The detailed agenda is posted on the web site, now. Cheers |---+-| |Wally Terhune |Register today for the premier U2| |U2 Support Architect |technical

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Nick Cipollina
Bill, If you are using MV.NET, it has its own connection pooling which is pretty well documented. That being the case, you don't even need to use the UO.NET built in connection pooling. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread phil walker
Wally, Two issues with this... * Firstly, where are they held and what costs are involved * Secondly, while Microsoft do offer courses for training which do cost money and held in our part of the world., there is also a vast library of information on the internet which people can go through

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Bill Haskett
Nick: We've developed an application in .NET using mv.NET to connect to UniData and the connectivity is screaming fast. A complete .NET developer does all our development and we do all the dbms design and implementation. The dbms development and connectivity gets done in no-time while the

[U2] RE: UO.NET Connection Pooling

2007-07-17 Thread Tony Gravagno
Bill Haskett wrote: ... I'm trying to find out how their Connection Pool license works. Noone seems to know nor can I find out how this integrates with mv.Net using UO.NET as the connection. I can't find out how to configure a connection pool, monitor the connections, or anything else.

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread LeRoy Dreyfuss
Bill, mv.NET from BlueFinity would be using standard UniObjects and as such, could not take advantage of connection pooling from U2 (CP). There may be licensing implications with U2 that require one to acquire CP licenses to use mv.NET, though. In any case, it is a simple matter of changing

Re: [U2] UV Command Stack

2007-07-17 Thread Ray Wurlod
For 99 read HISTSTK (configuration parameter) ;) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UV sentence stack

2007-07-17 Thread Ray Wurlod
The UniVerse sentence stack isn't stored anywhere. It is kept in the user's printer shared memory segment while the user is active. The .L command and the SYSTEM() function retrieve it from there. When the user exits from UniVerse, and if the VOC item STACKWRITE is set to ON, then the