Score:0

Has anyone here tried using ZWAMP as a dedicated SQL instance for long-term data collection?

in flag

By "ZWAMP", I mean this product, especially its MySQL implementation.

What I'm really aiming to learn here are the inherent, hardware independent, data storage size, complexity, and duration limitations associated with that software, if any; and whether it would be a very bad idea for me to put a ZWAMP instance onto a dedicated server (I'm running Windows Server 2012, but any server will do, I suppose) with plenty of storage space, and dump large (several tb) quantities of complex relational/historical data into it, with maybe up to a hundred simultaneous clients pulling and writing.

Suggestions for, or comparisons to, alternative free or equivalent WAMPs or SQL implementations are fine, but also please answer the questions as they pertain to ZWAMP in particular.

vidarlo avatar
ar flag
It's not been [active for 8+ years](https://sourceforge.net/projects/zwamp/files/). It would be a ***very*** bad idea to put 8 year old server software into production.
boxcartenant avatar
in flag
@vidarlo The sourceforge front page is a bit misleading -- the original designer, Bosca, hasn't updated it in 8 years, but it's GPL open source, and the project has been taken up by Cheejyg with updates as recent as 2021/06/11 (see here: https://sourceforge.net/p/zwamp/discussion/1093015/thread/5111873609/ )
boxcartenant avatar
in flag
But I suppose that won't change your advice lol. It doesn't seem to have been designed with commercial use in mind; I'm just curious if it *can* be used that way.
vidarlo avatar
ar flag
yes, it can. It's just a distribution of various components. For a production environment it's probably better to go to upstream, or a reputable vendor such as Debian or Redhat for bundles...
ua flag
Running large queries against TBs of data is likely to cause a meltdown. You need either smart software designed for TBs (there doesn't seem to be such), or you need a smart SQL programmer.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.