But I think mysql is a better choice, because it is used by so many
and so well tested.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Feb 22, 2007, at 10:43 AM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
Alan, Robert, and anybody else that might still respond, thank you
very much for your input.
I am looking to replace a MS SBS 2003 + Witango which worked great
so far with something else that is reasonably reliable, fast, easy
to use and supported.
This current system worked great, in more then four years it did
not break once (it it true, the load is not very heavy), but I
cannot legally use it anymore. MS does not allow more than 75 users
on SBS, no matter how much the customer is willing to pay. How
ridiculous is that?!
So I am looking to alternatives that will make the licensing issue
disappear.
PostgreSQL seems to be basically "no strings attached", which makes
it a first preference.
MySQL has a dual licensing policy, and I am afraid to not get into
something that later on will prove to be another nightmare. Another
issue is that the code changes are not immediately made available
to the "Community Server" (or, at least, CS is not the main focus
of the company).
Thanks again.
Mike Bravu
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 08:19
To: [email protected]
Subject: Re: Witango-Talk: OT: Witango hosting + DB
I have not used postgreSQL with it, but one thing to consider with
wtiango. I have not found witango to just work perfectly with any
DB. Even when other products seem to. It was one of the main
reasons, I changed to mysql, and then fell in love for many other
reasons. I spent months/years chasing down issues that usually only
occur under very heavy load. Under very heavy load, there are
issues of witango hanging and even crashing. Witango 5 was
notorious for this, and 5.5 was much improved, but it still
happens. But I have found it to be almost non-existent with mysql.
Probably because witango tests with mysql, and probably a couple of
others.
All that to say, if your stuff is at all intensive, set up some
scenarios, and hammer it on the bench, and see how witango likes it
first. I only tested a few DBs, but I found witango/mysql combo to
be about the most trouble free, and then probably witango/mssql.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Feb 22, 2007, at 1:15 AM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
Does anybody have any experience in using PostgreSQL + Witango ?
How does it compare with using MySQL?
Would you recommend PostgreSQL ?
[Sorry, I know this is OT but I checked the Witango-Talk archive
and could not find any message related to "PostgreSQL".]
Thank you,
Mike Bravu
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Monday, February 19, 2007 11:22
To: [email protected]
Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting
As far as ease of use, we purchased Navicat enterprise, that
solved any "MS is easier" issues. And one more thing, we never
chose mysql, especially for peach, because it was free. Peach,
actually told me no before, because it was free. They just
couldn't figure out, how anything free, could be any good.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Feb 19, 2007, at 8:17 AM, Jason Pamental wrote:
Stefan,
Well put. I think that there is enough research out there
supporting the speed and capabilities of both engines to argue
forever. Simply put though, MySQL is in use in enough high-
traffic and mission critical enterprise installations that any
blanket statements should be taken with a grain of salt. Rick - I
don't mean to take away from your own research - we all have to
rely in many cases on our own perceptions and experiences. But we
should all try to refrain from making statements that can so
easily undermine what others in the community are doing. I would
think that if Robert Garcia were to weigh in on this he could
spell out a very convincing case for MySQL given the tremendous
load his projects put it under on a daily basis. Of course, I use
SQL Server (2000 and 2005) as well as MySQL daily, and the ease
of management and use with SQL Server is amazing, so I tend to
lean towards SQL Server simply because I have it - but were I
faced with having to purchase the licenses myself, I'm not sure
I'd feel compelled to do so.
Cheers everyone-
Jason
-----
Jason Pamental
Director of Web Services
North Sails
Office: 401.643.1415
Fax: 401.643.1420
Mobile: 401.743.4406
Email: [EMAIL PROTECTED]
On Feb 19, 2007, at 10:21 AM, Stefan Gonick wrote:
Hi Rick,
Those arguments are a far cry from "yech". My point was just
that Mysql is a reasonable
database and it's free. It doesn't deserve that kind of negative
comment, which indirectly
casts aspersions on With. Obviously, their site doesn't need a
super high performance
database, so a free one is just fine.
Stefan
At 10:13 AM 2/19/2007, you wrote:
Hi Stefan,
I won’t get into a debate, but on Windows in a high-volume
production environment Microsoft SQL server is the fastest
hands-down, followed by Pervasive SQL a close second.
I’ve never bench-marked MSSQL on Windows vs. MYSQL on Linux,
but the research I have done stated that MSSQL is faster.
Also, I’ve done lots of work with MYSQL and in an environment
where the traffic is high, MSSQL doesn’t perform well. Again,
my experience has been on Windows.
<6b2db6b.jpg>
Rick Sanders
President
902-401-7689
www.webenergy-sw.com
Shop online for computer systems, accessories, and much, much
more! http://shop.webenergy-sw.com
From: Stefan Gonick [ mailto:[EMAIL PROTECTED]
Sent: February 19, 2007 10:45 AM
To: [email protected]
Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting
What is "yech" about Mysql? Since version 4 it has been a
quite usable database.
Stefan
At 09:37 AM 2/19/2007, you wrote:
I can’t believe they use MYSQL! Yech!
<6b2db7a.jpg>
Rick Sanders
President
902-401-7689
www.webenergy-sw.com
Shop online for computer systems, accessories, and much, much
more! http://shop.webenergy-sw.com
From: Wolf, Gene [ mailto:[EMAIL PROTECTED]
Sent: February 19, 2007 10:31 AM
To: [email protected]
Subject: Witango-Talk: OT: Witango hosting
This is a bit off topic. I'm looking for a hosting service
for my personal use. No, not business related. *laughs* If any
of you offer site hosting and Witango app hosting (and perhaps
database support as well) would you please send me some
information pertaining to costs? Yes, I did try the Witango e-
mail search looking for Hosting in the message title and
received the following error message:
Error
An error occurred while processing your request:
File: searchforum.taf
Position: DirectDBMS
Class: DBMS
Main Error Number: 1064
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max]You have
an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near
'ORDER BY w1.datereceived DESC limit 50' at line 12
23000
File: searchforum.taf
Position: DirectDBMS
Class: Internal
Main Error Number: -101
Gene Wolf
Supervisor, Business Systems
DRS Sensors & Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
321-309-0202 (fax)
Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/
This e-mail, including any attached files, may contain
confidential and privileged information for the sole use of the
intended recipient. Any review, use, distribution, or
disclosure by others is strictly prohibited. If you are not the
intended recipient (or authorized to receive information for
the intended recipient), please contact the sender by reply e-
mail and delete all copies of this message.
"This (document/presentation) may contain technical data as
defined in the International Traffic In Arms Regulations (ITAR)
22 CFR 120.10. Export of this material is restricted by the
Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be
exported to foreign persons without prior written approval from
the U.S. Department of State."
__________________________________________________________________
______
TO UNSUBSCRIBE: Go
to
http://www.witangocom/developer/maillist.taf
__________________________________________________________________
______
TO UNSUBSCRIBE: Go
to
http://www.witangocom/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
CoachVille: For coaches and people taking teleclasses
http :// www.cvcommunity.com?af=69474
__________________________________________________________________
______
TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
__________________________________________________________________
______
TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
CoachVille: For coaches and people taking teleclasses
http :// www.cvcommunity.com?af=69474
___________________________________________________________________
_____
TO UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf
____________________________________________________________________
____
TO UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.2/692 - Release Date:
2/18/2007 16:35
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/696 - Release Date:
2/21/2007 15:19
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3 - Release Date:
2/19/2007 00:00
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3 - Release Date:
2/19/2007 00:00
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
