Page Comparison

[09:48:57 EDT(-0400)] * ac_chan (n=alex@tempoutsidepix.pratt.edu) has joined ##uportal
[09:49:00 EDT(-0400)] <ac_chan> hello
[09:59:47 EDT(-0400)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has joined ##uportal
[10:07:06 EDT(-0400)] <ac_chan> hello
[10:07:15 EDT(-0400)] <EricDalquist> good morning
[10:07:33 EDT(-0400)] <ac_chan> we did a beta launch of uportal this morning..
[10:07:43 EDT(-0400)] <ac_chan> getting java heap issues now...
[10:07:51 EDT(-0400)] <ac_chan> but other hten that..
[10:07:55 EDT(-0400)] <ac_chan> we are a ok.
[10:07:55 EDT(-0400)] <EricDalquist> did you do any performance tuning before the launch?
[10:07:57 EDT(-0400)] <EricDalquist> cool
[10:08:10 EDT(-0400)] <ac_chan> we didn't due to the tight deadline we had
[10:09:10 EDT(-0400)] <EricDalquist> ah
[10:09:41 EDT(-0400)] <EricDalquist> yeah, tuning the JVM for your hardware & expected usage patterns is pretty important with pretty much any enterprise java app
[10:10:03 EDT(-0400)] <EricDalquist> there are some good pages in the uportal wiki with example configurations and overviews of how to do tuning
[10:11:59 EDT(-0400)] <ac_chan> we are looking at it now
[10:12:30 EDT(-0400)] <ac_chan> should running hsqldb in embedded mode hinder performance?
[10:15:48 EDT(-0400)] <EricDalquist> YES
[10:15:57 EDT(-0400)] <EricDalquist> HSQL DB is not safe to use in a production environment
[10:16:11 EDT(-0400)] <ac_chan> oh ..
[10:16:14 EDT(-0400)] <ac_chan> damn.
[10:16:25 EDT(-0400)] <EricDalquist> performance won't be too much of an issue
[10:16:29 EDT(-0400)] <EricDalquist> but
[10:16:38 EDT(-0400)] <EricDalquist> it doesn't provide locking
[10:16:44 EDT(-0400)] <ac_chan> we should have went with postgresql
[10:17:16 EDT(-0400)] <EricDalquist> so if two threads try to make atomic changes to one table or dataset you're not going to get expected results
[10:17:31 EDT(-0400)] <ac_chan> oh ok
[10:22:10 EDT(-0400)] <ac_chan> so postgresql would be better then..
[10:25:14 EDT(-0400)] <EricDalquist> well use whatever database you have experience with
[10:25:27 EDT(-0400)] <EricDalquist> but HSQLDB is just used by default for demonstration & development purposed
[10:25:31 EDT(-0400)] <EricDalquist> purposes*
[10:28:47 EDT(-0400)] <ac_chan> i am most comfortable with mysql .. but it uportal seems to act weird with it
[10:30:50 EDT(-0400)] <EricDalquist> brb
[10:31:10 EDT(-0400)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has left ##uportal
[10:32:50 EDT(-0400)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has joined ##uportal
[10:33:06 EDT(-0400)] <EricDalquist> what mysql issues have you had?
[10:37:42 EDT(-0400)] * clown (n=chatzill@guiseppi.atrc.utoronto.ca) has joined ##uportal
[10:58:42 EDT(-0400)] <ac_chan> well for some reason. we had case sensitvity issues with table names
[10:58:53 EDT(-0400)] <EricDalquist> ah
[10:59:04 EDT(-0400)] <EricDalquist> I believe that is a known issue with mysql on linux/unix
[10:59:06 EDT(-0400)] <ac_chan> and when we logged in as db users..
[10:59:10 EDT(-0400)] <EricDalquist> well not really a mysql issue
[10:59:22 EDT(-0400)] <EricDalquist> but an issue with mysql & uportal since it isn't using consistent case
[10:59:25 EDT(-0400)] <ac_chan> instead of admin user..
[10:59:43 EDT(-0400)] <ac_chan> displayed on login we got '0'
[11:00:09 EDT(-0400)] <ac_chan> all of our stuff is running freebsd
[11:02:53 EDT(-0400)] <EricDalquist> ah, well if you'd rather use mysql I'd check with the list about options for making mysql not case sensitive or to see if others have figured out the places in uPortal that need fixing for case sensitivity.
[11:05:46 EDT(-0400)] <ac_chan> postgresql is ok with me also though