passing data in n-tier apps

[mchu7aa3]

Hi,

What is the best way to pass BIG data across machine/process boundaries in an n-tier COM application???
(Objects, Strings, UDTs, Arrays....)????

[Swatty]

UDT and Objects.

With objects you can do more.

You can store extra code in the creatiion/destruction of them.

[mchu7aa3]

Thanx,

but I am more concerned with issues such as: performance, network congestion etc???

[BBB]

I've oftern used the 'Dictionary' data type send large amounts of data from app to app.

[mchu7aa3]

I don't know about the Dictionary data type!!! could you please explain. and where can I get example source code and tutorial on it?

[Fried Egg]

Why not just use recordsets?

[mchu7aa3]

I was thinking of using Recordsets to pass data from the Business layer to the Client Tier on another machine, but I thought the Client Tier should be free from data access code or reference??

[BBB]

You need : \system32\scrrun.dll (Which I'm sure you have)

Make a reference to 'Microsoft Scripting Runtime'

Private Sub Form_Load()

Dim dicTemp As New Scripting.Dictionary
Dim col1 As New Collection
Dim strZ As String
Dim lngY As Long
Dim intX As Integer
Dim objFSO As New FileSystemObject

intX = 32
lngY = 1000000
strZ = "ABC"
Call col1.Add("Adele", "32")
Call col1.Add("Tim", "23")
Call col1.Add("Alex")
Call col1.Add("Jade")

Call dicTemp.Add("No1", intX)
Call dicTemp.Add("No2", lngY)
Call dicTemp.Add("No3", strZ)
Call dicTemp.Add("No4", col1)
Call dicTemp.Add("Object", objFSO)

MsgBox dicTemp.Item("No1") & vbNewLine & _
dicTemp.Item("No2") & vbNewLine & _
dicTemp.Item("No3") & vbNewLine & _
dicTemp.Item("No4").Item("32") & vbNewLine & _
dicTemp.Item("No4").Item("23") & vbNewLine & _
dicTemp.Item("No4").Item(3) & vbNewLine & _
dicTemp.Item("No4").Item(4) & vbNewLine & _
TypeName(dicTemp.Item("Object"))

End Sub


Sorted .... hope this helps.

I use it as a container to cut down on messy method signatures that need loads of parameters passed in.

BBB