For some reason the PHP Debugger is throwing a fit with this message. I'd appreciate if you guys would take a look at the attached text though.
TIA
Cheers
Kahuna wrote:Structuring a Solution for Multi-Clients / Multi-Db's
Hi Folks - this is possibly in the wrong forum - but here goes - feel free to move me around!
------------------------------------------------------------------------------
Covering some old ground here , but I need to get this straight in my head before we detail the MSA97 app port to Servoy.
Currently the app is a Front / Backend set-up. I have several Clients each of whom has several databases running , i.e.:
Client1
--------?DBa
----------------?CostsTablei
--------?DBb
----------------?CostsTablei
--------?DBc
----------------?CostsTablei
Client2
--------?DBa
----------------?CostsTablei
--------?DBb
----------------?CostsTablei
--------?DBc
----------------?CostsTablei
Each ClientUser has a frontend on his PC (or TS Desktop) connecting to a ClientServer where (all of) the Backend(s) reside.
Each of the CostsTable's can have different data dependant on the Client requirements for that DB, though the field names and ID's are the same. The structure of each DB is identical and simply named differently.
Currently upgrading is a nightmare , each copy of the frontend needs to be updated, links inside the frontend have to be modified after installation (so the specific user gets to the right database a,b or c , some need access to all etc.) and of course the backend needs to be downloaded to my dev box , modified and re-uploaded to the Client server.
In future, some Clients will use the Smart Client over the web to our servers, and some will have the system installed on their own servers and use the Lan / Wan. I'm hoping to use the WebClient too eventually.
Thinking about how we could do it differently, and ease the upgrade path lead me to these two main question:
1. Using Our / Client Servers:
With multiple Clients using the same solution, can I drive Client1 to DBa and Client2 to DBb etc? They can't (with the current structure) use the same CostsTables (and other tables) so diferent DB's are essential.
FYI: It would be possible to have all Client DB's in one huge structure and 'Filter' only the data for a given (current) DB's data. That would require a fairly dramatic restructuring however and entail a pretty big revision of the current Client data tables , I'd like to avoid that. With our current Clients having 20 , 30,000 records in the main tables and the same in cost files, aggregating several of them (Clients) in one DB would almost certainly cause performance challenges.
2. Can the above be done and still retain a common solution for both Our / Client server installations, or do I need a separate Solution for each Client / DB.
I'd really appreciate your feedback on these structures , before we get too far down the line (we'll need to get quite a way forward to test these for ourselves).
Anyone had similar challenges
Cheers
Kahuna wrote:1. Using Our / Client Servers:
With multiple Clients using the same solution, can I drive Client1 to DBa and Client2 to DBb etc? They can't (with the current structure) use the same CostsTables (and other tables) so diferent DB's are essential.
Kahuna wrote:FYI: It would be possible to have all Client DB's in one huge structure and 'Filter' only the data for a given (current) DB's data. That would require a fairly dramatic restructuring however and entail a pretty big revision of the current Client data tables , I'd like to avoid that. With our current Clients having 20 , 30,000 records in the main tables and the same in cost files, aggregating several of them (Clients) in one DB would almost certainly cause performance challenges.
Kahuna wrote:Thanks to you both - Robert and Marcel.
My message did'nt have any umlats in there to start with! But did have hanging quotes as you point out.
Kahuna wrote:Thanks for the feedback on the server setup.
I'd still like to have seperate databases (dataservers?) and switch between them.
Any guidance on how that might be facilitated based on the User / Group login?
Broad-brush please guys - I'm sure most of this will be revealed as we progress through the development - and I dont want to bog the forum down with NooB questions, but point in the right direction would always be welcome.
Users browsing this forum: No registered users and 8 guests