stupidly Big Universes

general discussion
1

How many objects would you class as to large ?

I had a job interview yesterday and the job spec said complex universe when I asked them about this they said they had 13,000 objects in the universe :blue: :blue: :blue: , they seemed to think it was reasonable number.

Fiona :uk: (BOB member since 2002-12-16)

2

Too big IMHO, way too big, but if they are happy with it and are able to maintain it :twisted:

Andreas :de: (BOB member since 2002-06-20)

3

Not seen one that big…but to be honest the issue with universes is usual organisation rather than sheer size :slight_smile:

If the classes and tables are structured well you can support a lot of objects and still maintain usability, for consumers and developers.

cashworth (BOB member since 2005-02-09)

4

Was it based on their own database or one of these third party universes for finance / HR products? There are some horrible universes out there for things like Coda, Midland HR…but my recollection is of a few thousand objects not 13,000.

Nick Daniels :uk: (BOB member since 2002-08-15)

5

This sounds way, way, too big. Not something to be boasting about, surely ;).

I wouldn’t want to use it, let alone maintain it. It must of being based on the whole of an OLTP structure!

Mak 1 :uk: (BOB member since 2005-01-06)

6

Did you ask them if they run the famous Dwayne’s macro to document it. Just to troubleshoot Dwayne’s job :mrgreen:

7

Were you interviewing here?? Sounds like the crap we do for our services group. Everything has to be in the universe - don’t we understand that universe means everything??

If you’re stuck with this, best you can do is to organize the objects into meaningful categories and bite your tongue.

We did manage to split off one large folder into its own universe, but that was more of a symbolic victory… Reports still ran when pointed to this new universe, since our ojbect IDs were the same - just an idea you might pursue…

B

bdouglas :switzerland: (BOB member since 2002-08-29)

8

Feel reassured I have seen eve bigger and crazier universes.

the largest One I have seen (they are not all in the same universe)
Tables +6,000
Objects +30,000
Contexts +100

Reports
+150 data providers
+2,000 local variables

In these cases don’t ask and try to work with them.
Are some of them useless and not user friendly definitely.

Try to be good master of the universe and prove the theory wrong a universe is not always expanding, well at least in BO it should not

When the term was coined in the early day’s of BO(in french) it meant the are I am familiar with and I know for my daily job.
Some of these folks must have very complex jobs then.

ClaireB :de: (BOB member since 2002-08-09)

9

Looking at the swiss flag on your avator it could well be your lot, company name isn’t very long and has an S in it ? If it is whats it like to manage how do users find it ?

Fiona :uk: (BOB member since 2002-12-16)

10

How long does it take to import it from the repository when you want to do a change? And how long does it take to export it back? :shock:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

11

It’s not us, lucky for you : )

Our biggest universe takes 45 min to export, much worse for our developers in India working over our WAN - XI made this better, but only slightly.

B

  • the Swiss flag is a misrepresentation, too - I’m American, but my background is too diverse to pick a good flag : )

bdouglas :switzerland: (BOB member since 2002-08-29)

12

So you’ll be giving a chance to work on the universe… :frowning: ?

looksmee :uk: (BOB member since 2006-02-08)

13

YIKES :shock:

Anything over a minute for me would be rather annoying.

Namlemez :djibouti: (BOB member since 2005-03-14)

14

Except reading the entire Michael’s thread :mrgreen:

15

:stuck_out_tongue:

I’d be afraid to take a job, if I would be expected to maintain a universe like that. It would take a year just to understand it. :shock:

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

16

I worked on a massive one once, 6000 or so objects, many contexts, many reports, lots of Freehand SQL.
Almost the whole of the organisations replicated OLTP in one universe. Lets just say, they were an online business with many applications…:).
They also had one of the most complex SDK solutions I had seen, this was used by every report.
There was also a spreadsheet, which was a major data provider, if someone left it open at the weekend…well…:wink:
I would have to then monitor all of the full client jobs, on a Monday, which had failed, constantly firefighting the queue.

In addition they only had one machine split by domains . :wah:

Mak 1 :uk: (BOB member since 2005-01-06)

17

Apperently it was a conscious descision to make it that big from the start so it wasn’t even by accident, they didn’t like the fact I questioned it, upto them in the end but not for me it would be a nightmare to maintain, and it’s true what they say ‘bigger isn’t always better’ :lol: :lol: . Got another job anyway in the end :mrgreen: :mrgreen: woohooo

Fiona :uk: (BOB member since 2002-12-16)

18

Well, my guess is that you wouldn’t have wanted to work there anyway.

My view is, always, why have me here anyway, i.e. why buy a dog and bark yourself… :rotf:

Sweet…:slight_smile:

Mak 1 :uk: (BOB member since 2005-01-06)

19

Glad, you found something else, Fiona :+1:

Andreas :de: (BOB member since 2002-06-20)

20

You will be really lucky if that universe will work with Webi. Every time you open the query panel it downloads the universe on to the local machine (zero footprint?).

Imagine what will happen to the comms links if you have 3 or 4 developers building some multi query reports in Webi. I reckon things might slow down a bit if the comms links aren’t up to scratch.

This differs of course if you are using a client/server application such a Deski or Webi rich client as these can use local copies of the universe.

DoubleStew :uk: (BOB member since 2003-12-15)