From: Ellen K. 

On Wed, 24 Mar 2004 19:55:51 +0200, "Antti Kurenniemi"
 wrote in message
:

>"Ellen K." 
wrote in message
>news:uqb360ls4udrhr6kl46h55fkq822m1u581{at}4ax.com...
>> >I have 6 now and an empty 6 disk case so 12 in total. 1 for
the system, 1
>> >hotswap, so 10 to use for whatever I want basically. Should be a lot of
>fun
>> >
>> >
>> Cool, this should give you enough room to do stuff!
>
>Yep, should open a whole bunch of new possibilities.
>
>
>> You should use 2 for the transaction log, that leaves 8...
>> probably 2 3-disk RAID5 arrays for the data and clustered
>> indexes (each clustered index lives in the same data file as
>> the table it belongs to), which means you can split up
>> your 4 tables however works best,
>
>Will have to play with that. There are some 200+ tables in total, but most
>of the stuff runs in these 4 (or actually 5) tables.
>
Transaction log still needs to be by itself.

Regarding the 200 tables, split up the 4 to 5 that are used all the time
such that those that constantly join with each other are on different
disks, the other 195 just split up to make the amount of data about even.


>
>> > I'm much too scared of how the current system
>> > would handle errors like that. It's a real weird system.
>>
>> Do you have the source code for it?
>
>After I threatened to resort to physical violence, they finally gave me
>partial source code (their lead programmer is in Sweden, and at one phone
>conference when I was a bit, eh..., tired, they said he couldn't help me
>because he was in another country - I said well that's fine by me, it takes
>me two hours to fly there to punch him in the face, and that I'd be
>perfectly happy to do that and as a matter of fact I wouldn't mind smacking
>the shit out of the rest of the bunch while I was at it - I know I know, not
>exactly a polite approach but hey, it worked ).

HAAA, I LOVE IT!    :)

>It's not the actual
>engine part but all the business logic, which helps a lot - but it's not
>documented code and there's a huge pile of it. Doesn't solve the problem,
>but helps every now and then.
>
The engine isn't the important part, you've already got the right idea by
moving the back end to a real RDBMS.

Documented, shmocumented, if you have the source code you can figure out
what's going on.   Good for you for getting it, I am way impressed!
:)
>
>Antti Kurenniemi
>

--- BBBS/NT v4.01 Flag-5