Re: PostgreSQL vs MySQL with Tomcat

Leon Rosenberg wrote: On Fri, Jan 23, 2009 at 12:59 PM, Chris Wareham wrote: Reread my last message, and take a look at the internals of any half decent RDBMS. Frequently accessed data will get cached in memory, and the cost of many joins will be less than the cost of a hash table lookup in

Re: PostgreSQL vs MySQL with Tomcat

Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris, Chris Wareham wrote: I am particularly wary of MySQL because of the way missing features have been disingenuously described as unnecessary, and broken features as the MySQL developers knowing better than everyone

Re: PostgreSQL vs MySQL with Tomcat

Leon Rosenberg wrote: On Fri, Jan 23, 2009 at 12:36 PM, Chris Wareham wrote: So you perform two queries from the application layer? You are basically doing a join by hand - the cost of those two round trips to the database will lose to a single query with a join, unless you've not

Re: PostgreSQL vs MySQL with Tomcat

Leon Rosenberg wrote: On Fri, Jan 23, 2009 at 11:45 AM, Chris Wareham wrote: By it's very definition (see Codd or Date), an RDBMS should be capable of performing joins with good performance. MySQL often struggles to do so thanks to the poor optimiser, so you had to implement what shou

Re: PostgreSQL vs MySQL with Tomcat

lem with much of the LAMP crowd - they've never tried anything else, so when they hit this kind of problem they assume it's a limitation of the kind of tools they are using, not of the specific tools themselves. Chris -- Chris Wareham Senior Software Engineer Visit London Ltd 6th floor, 2

Re: run tomcat as tomcat user

p tcp --destination-port 80 --to-ports 8080 # /sbin/iptables -A FORWARD -p tcp --destination-port 443 -j ACCEPT # /sbin/iptables -t nat -A PREROUTING -j REDIRECT -p tcp --destination-port 443 --to-ports 8443 # /sbin/service iptables save # chkconfig iptables on # service iptables start Hope th

Re: PostgreSQL vs MySQL with Tomcat

own to be buggy versions of MySQL are down to pressure from Sun to get something, anything, to market. A cynic would say that's always been part of MySQL's problems, and that it's generally true of most commercial software (open or closed source). Chris -- Chris Wareham Senior Software

Re: PostgreSQL vs MySQL with Tomcat

urages bad habits, and commonly adds to the bugginess of PHP applications where MySQL is the de-facto standard for persistence. I'd strongly recommend you try another database engine such as PostgreSQL or Firebird, and compare MySQL for performace, scalability and standards conformance. Chris --

Re: PostgreSQL vs MySQL with Tomcat

less time analysing query plans and optimising by hand when using PostgreSQL rather than MySQL, as the former handles joins across more than one table far better. Thanks much in advance, Ken Bowen Chris -- Chris Wareham Senior Software Engineer Visit London Ltd 6th floor, 2 More London Rivers

Re: jvm cowardly refuses to print a thread dump

topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ You live life online. So we put Windows on the web. http://clk.atdmt.com/MRT/go/127032869/direct/01/

Re: mixed html and jsp site using ProxyPass

André Warnier wrote: Chris Wareham wrote: David Goodenough wrote: The reason was that Tomcat did not serve the Flash correctly, never did manage to get to the bottom of why but the browser did not complain - it just left big blank spaces. With this setup at least that bit works. David My

Re: mixed html and jsp site using ProxyPass

ache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Chris Wareham Senior Software Engineer Visit London Ltd 6th floor, 2 More London Riverside, London SE1 2RR Tel: +44 (0)20 7234 5848 Fax: +44 (0)20 7234 5753 www.visitlondon.com &#

Re: mixed html and jsp site using ProxyPass

entirely, and have Tomcat handle the requests directly. On a Unix system, you can still run Tomcat as an unprivileged user by having it listen on ports 8080 and 8443 for example, and using firewall rules to forward incoming requests from ports 80 and 443 respectively. Chris -- Chris Wareham Senior

Re: Compiling JSPs - how to ignore files with certain extensions.

Tim Funk wrote: For the OOM error - you might want to add compile="false" to your jsp2 task so compilation is not done. (.tag files still end up being compiled but thats a different issue) Then for your javac task add (increase as appropriate) fork='true' memoryInitialSize='192m' memoryM

Re: Compiling JSPs - how to ignore files with certain extensions.

Tim Funk wrote: I suspect that you have a file which includes header.jspf - and that parent file is not including the fn tag lib. (The (potentially) bad error message is another issue) -Tim Yes, there was one file with a .jsp extension that didn't include taglibs.jspf before header.jspf. No

Re: Compiling JSPs - how to ignore files with certain extensions.

Tim Funk wrote: What tomcat version and commands are you using? IIRC - jspf files by default are not precompiled. I started with Tomcat 5.0.30, but have switched to 5.5.12. The ant targets that I am using is similar to the ones in the Tomcat docs:

Compiling JSPs - how to ignore files with certain extensions.

I have a web app structured as follows: myapp/footer.jspf myapp/header.jspf myapp/index.jsp myapp/taglibs.jspf myapp/WEB-INF/... I would like to add a target to my Ant build.xml to precompile the JSPs, so that I can check they do not reference any unknown custom tags. However, JspC appears