This is just my biased opinion: 1) MySQL was fatser than postgresql when it had no transaction 2) MySQL has lots of quirks (like max length for text files, no multiple alter table in one transaction, and others) 3) MySQL was developed by SUN which was bought by Oracle and it is not clear what it future is. Some developers have left 4) I use postgresql so I have tested it better 5) There are very large postgresql databases I know of (like the .org domains database), I cannot say the same for mysql (but it may be my ignorance). 6) postgresql has autovacuum so you do not need to do much maintenance.
On Oct 23, 12:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > Why do you suggest postgresql? I have done alot of research into the two, > and mysql seems to be the more effeciant of the two. > > From what I gather, mysql is created to be lightweight, and super fast. > Postgresql is created to be feature full and stable. > > However, dreamhost does not provide postgresql on their shared hosting, so > for now I will have to use mysql. > > The site is a web app that tracks fish tanks on gaiaonline.com. Basically, > gaia has this mini game called "Booty Grab" (here is more > infohttps://www.gaiaonlinehelp.com/ics/support/KBAnswer.asp?questionID=17), > that > glows at random times. The only way to find if their glowing, is to go > through pages and pages of forums... very boring, annoying, and cpu > intensive with all of the flash on one page.. > > Well... My app will contact gaia, ask it for information on a tank, such as > when it will be open, and for how long, it stores this data in the database, > and displays hyperlinks when pages are available. > > http://surrenderthebooty.thadeusb.com/ > > Your welcome to sign up if you would like to see the internals. > > When attempting to migrate over to mysql, I get an error about key length > too long, refer to my other > post:http://groups.google.com/group/web2py/browse_thread/thread/27d781db1f... > > On Thu, Oct 22, 2009 at 8:14 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > Move to postgresql not mysql ;-). If I may, what is the site? I am > > curious. > > > On Oct 22, 7:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > > > It seems as if now, I am not recieving any 503 errors. This must be due > > to > > > the ammount of growth the site recieved in such a short period of time, > > not > > > to mention i'm running it in a shared hosting environment, there is > > nothing > > > I can do except get a dedicated server, or perhaps figure a way to limit > > the > > > requests based on a random timer. For some odd reason, get requests load > > > faster, but this could just be a fluke in the environment. > > > > I have been browsing through error tickets, and it seems that since my > > > database (sqlite) grew from only 100 tracked items to 1460 tracked items > > in > > > a little over a few hours, every ticket recieved is about migration > > > EOFErrors. I will try exporting everything to csv, switching over to > > mysql, > > > and reimporting. Perhaps this will fix some of the performance issues, > > and > > > the EOF errors.. > > > > S'Traceback (most recent call last):\n File "gluon/restricted.py", > > > line 184, in restricted\n exec ccode in environment\n > > > File "/home/.idiosyncrasy/thadeusb/ > > > thadeusb.com/surrenderthebooty/applications/init/models/db.py", > > > line 42, in <module>\n auth.define_tables() > > > # creates all needed tables\n > > > File "gluon/tools.py", line 601, in define_tables\n > > > self.settings.table_permission_name, migrate))\n > > > File "gluon/sql.py", line 1130, in define_table\n > > > query = t._create(migrate=migrate)\n > > > File "gluon/sql.py", line 1501, in _create\n > > > sql_fields_old = cPickle.load(tfile)\nEOFError\n' > > > > -Thadeus > > > > On Thu, Oct 22, 2009 at 3:29 PM, Thadeus Burgess <thade...@thadeusb.com > > >wrote: > > > > > I can post code later tonight when I get home, I can't even make any > > > > changes to code until then since it is a personal project. > > > > > I will try using a GET request instead, since no data is being passed > > > > through post anyways. > > > > > It is an apache thing, its just odd I only get it when using ajax. It > > did > > > > not start happening until today when the site received a major influx > > of new > > > > content to track. > > > > > There is no way for me to increase threads or processes since this site > > is > > > > on shared hosting :( > > > > > -Thadeus > > > > > On Thu, Oct 22, 2009 at 3:09 PM, mdipierro <mdipie...@cs.depaul.edu > > >wrote: > > > > >> 2py never returns 503. Are you using apache? It may be running out > > > >> of threads or proc --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
