Reply to thread

Message

Hi ajs

I've done the lion's share of making MP and Configuration work as multi-user applications with the FoldeDatabase, MusicDatabase, PictureDatabase and VideoDatabase.

Are there any third-party applications that use the MusicDatabase because I notice that MusicDatabase isn't really using a relational design and it doesn't perform very well compared with the other databases? I am very tempted to sort that out while I'm doing the the rest (because I'm having to re-code much of the back-end anyway). It will add a bit of work but relative to what I've already done it won't be much - this has been a mammoth task.

What do you think?

There are sections, not many though, that generate SQL on-the-fly, which doesn't lend itself to object-orientation, so I've left that coding alone. It's okay for my purposes because those sections only affect reads and not updates/writes.

Things are going well and the performance is great though I've still got a lot of testing to do.

Tony

<blockquote data-quote="Anthony Vaughan" data-source="post: 1286436" data-attributes="member: 153283">Hi ajsI've done the lion's share of making MP and Configuration work as multi-user applications with the FoldeDatabase, MusicDatabase, PictureDatabase and VideoDatabase.Are there any third-party applications that use the MusicDatabase because I notice that MusicDatabase isn't really using a relational design and it doesn't perform very well compared with the other databases? I am very tempted to sort that out while I'm doing the the rest (because I'm having to re-code much of the back-end anyway). It will add a bit of work but relative to what I've already done it won't be much - this has been a mammoth task.What do you think?There are sections, not many though, that generate SQL on-the-fly, which doesn't lend itself to object-orientation, so I've left that coding alone. It's okay for my purposes because those sections only affect reads and not updates/writes.Things are going well and the performance is great though I've still got a lot of testing to do.Tony</blockquote>

[QUOTE="Anthony Vaughan, post: 1286436, member: 153283"] Hi ajs I've done the lion's share of making MP and Configuration work as multi-user applications with the FoldeDatabase, MusicDatabase, PictureDatabase and VideoDatabase. Are there any third-party applications that use the MusicDatabase because I notice that MusicDatabase isn't really using a relational design and it doesn't perform very well compared with the other databases? I am very tempted to sort that out while I'm doing the the rest (because I'm having to re-code much of the back-end anyway). It will add a bit of work but relative to what I've already done it won't be much - this has been a mammoth task. What do you think? There are sections, not many though, that generate SQL on-the-fly, which doesn't lend itself to object-orientation, so I've left that coding alone. It's okay for my purposes because those sections only affect reads and not updates/writes. Things are going well and the performance is great though I've still got a lot of testing to do. Tony [/QUOTE]