COM-RPCServer - New Version
in [Visual Basic]
|
From: RB Smissaert on 14 Apr 2007 13:40 > You mean, regarding the additional > "Server-Load", running time-consuming queries > in parallel to the Interbase-Engine? Yes, that is the one I was worried about. Will let you know when I have some results. RBS "Schmidt" <sss(a)online.de> wrote in message news:upLklorfHHA.4980(a)TK2MSFTNGP02.phx.gbl... > > "RB Smissaert" <bartsmissaert(a)blueyonder.co.uk> schrieb im Newsbeitrag > news:Oqob5FrfHHA.2640(a)TK2MSFTNGP06.phx.gbl... > >> ... The main problem I can see is the effect that running queries >> on this SQLite file would have on the performance of Interbase. > You mean, regarding the additional "Server-Load", running > time-consuming queries in parallel to the Interbase-Engine? > > Think, you should look at the current load of your W2K-machine > when the Interbase-Server has its "rush-hour" - if there are 50% > left over (many DBMS don't use the full CPU-Power whilst > running complex queries, because they have to wait for the > Disk-IOs to complete), then there are good chances IMO, > especially, if you can place the SQLite-DB-File on a different > HardDisk. > >> > my converter-class >> >> Where was this class again? > Inside the original SQLite-Demo-Zip. > >> > I'd say, simply create a SQLite-pendant at least for your >> > "worst-case"-tables and the currently slowest performing >> > Select ... >> >> Will have a go at that and thanks again for the help. > Let me know your results, or when you need help, putting > it behind the RPC-Server. > > Olaf > >
From: Schmidt on 15 Apr 2007 05:47
Ok, here come the commented Client-Sources - once for the DB-Demo- and for the COM-Demo-Client too. www.datenhaus.de/Downloads/RPCSourceDemoClients.zip The COM-Demo is going more into detail, covering (more or less) all of the features of this "DCOM-Replacement" - mainly thought for those, who want to "dive into deep" ;-) The DB-Demo covers only the needed parts of the RPC- mechanisms and is probably the better recommendation for a quick overwiew. Both demos (please read: '_Before you start.txt' first) allow a client-side RoundTrip-Debugging using the normal "VB-F8-Mode", as long as the DebugMode-Switch is set to true, and if the project was loaded prior as a VB- ProjectGroup (containing the appropriate Server-Dll-Project). The Code inside the Modules is not too voluminous (ca. 40-50 lines on average) - think, if you invest ca. half an hour into the DB-Demo-Source, then you already got a very good overwiew and understanding about the whole RPC-thing. Olaf |