RE: PostGreSQL
yes. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 14, 2000 3:07 PM To: CF-Talk Subject: PostGreSQL Anyone out there using PostGreSQL with ColdFusion? Ian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: PostGreSQL
>yes. Chris, Are you using Postgres as a backend machine to CF/Win? If so, do you have a how-to or other document? Len http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 installable binary for NT4 http://IMGate.MEIway.com: Build free, hi-perf, anti-spam mail gateways -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: PostGreSQL
actually, i used it as a backend to CF on Linux. what are you trying to do? a "how to" is hard to come up with unless i know what you're after. of course, there's alwasy www.postgresql.org and the full documentation set...:) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 14, 2000 4:42 PM To: CF-Talk Subject: RE: PostGreSQL >yes. Chris, Are you using Postgres as a backend machine to CF/Win? If so, do you have a how-to or other document? Len http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 installable binary for NT4 http://IMGate.MEIway.com: Build free, hi-perf, anti-spam mail gateways -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: POSTgreSQL
> Anyone tried PostgreSQL with Coldfusion? What OS. I know a few people who have used it under Linux and Solaris but I've not heard of anyone using it successfully under Windows. In fact if anyone ahs gotten it to connect to CF on a Windows box I'd like to hear how they did it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: POSTgreSQL
Correct me if I'm wrong, but I don't think there's a Windows port of PostgreSQL. It's only available on Solaris and Linux and other Unix flavours... -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:36 AM To: CF-Talk Subject: RE: POSTgreSQL > Anyone tried PostgreSQL with Coldfusion? What OS. I know a few people who have used it under Linux and Solaris but I've not heard of anyone using it successfully under Windows. In fact if anyone ahs gotten it to connect to CF on a Windows box I'd like to hear how they did it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: POSTgreSQL
Zac Belado wrote: >>Anyone tried PostgreSQL with Coldfusion? >> > > What OS. I know a few people who have used it under Linux and Solaris but > I've not heard of anyone using it successfully under Windows. > > In fact if anyone ahs gotten it to connect to CF on a Windows box I'd like > to hear how they did it. We are connecting CF on NT to PostgresQL on OpenBSD. Just test your ODBC drivers carefully before you install them on a production box and it should be a smooth ride. I just didn't reply before because I have zero experience with doing full text searches on anything more than a rows=3216 width=251 table. Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: POSTgreSQL
> Correct me if I'm wrong, but I don't think there's a Windows port of > PostgreSQL. It's only available on Solaris and Linux and other Unix > flavours... There are win32 binaries and there are directions on how to compile it using the cygwin tools. That's about it though ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: PostgreSQL
Yves Arsenault wrote: > > I was wanting to play around with PostgreSQL, so I created a DB, went into > the CFadmin. > > I used to following info: > Driver: Other > JDBC URL: jdbc:postgresql://server:port/database > Driver Class: org.postgresql.Driver > > I entered the username and password that I created. > I got an error.. (sorry didn't write it down), it couldn't connect to the > DB. Make sure you write it down next time :-) > Now, when I tried to modify the info that I entered, I get this error: > "File not found: /datasources/postgresql.cfm " http://www.houseoffusion.com/lists.cfm/link=m:4:27942:140790 Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Yves, On 3/1/2004 at 11:53, you wrote: YA> I used to following info: YA> Driver: Other YA> JDBC URL: jdbc:postgresql://server:port/database YA> Driver Class: org.postgresql.Driver YA> I entered the username and password that I created. I got an YA> error.. (sorry didn't write it down), it couldn't connect to the YA> DB. Now, when I tried to modify the info that I entered, I get YA> this error: "File not found: /datasources/postgresql.cfm " YA> Anyone have any suggestions? YA> I did look in the datasources folder, and such a file does not YA> exist... I could see one for Oracle, MySQL but no PostgreSQL. The instructions at Jochem's site* worked for me mostly, though I had to add my PostgreSQL server's port number to the JDBC URL**. Without the port number, I got that same misleading postgresql.cfm error. There was a postgresql.cfm file in MX6.0, but it is apparently not used in MX6.1 at all; however, there seem to be some references to it remaining in MX6.1's CF Admin. To remove/correct the flawed DSNs, edit /opt/coldfusionmx/lib/neo-query.xml Here's how my RH 9/MX 6.1/PostgreSQL 7.3.4 JDBC URL's are formatted: jdbc:postgresql://127.0.0.1:[PostgreSQL port number]/[database] (*) http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 (**) http://jdbc.postgresql.org/doc.html#load (see JDBC URL section) Hope that helps! ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Thanks for the reply... As I received this message, I found that same page. Love those archives! Yves On Mon, 23 Feb 2004 18:17:03 +0100, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Yves Arsenault wrote: >> >> I was wanting to play around with PostgreSQL, so I created a DB, went >> into >> the CFadmin. >> >> I used to following info: >> Driver: Other >> JDBC URL: jdbc:postgresql://server:port/database >> Driver Class: org.postgresql.Driver >> >> I entered the username and password that I created. >> I got an error.. (sorry didn't write it down), it couldn't connect to >> the >> DB. > > Make sure you write it down next time :-) > > >> Now, when I tried to modify the info that I entered, I get this error: >> "File not found: /datasources/postgresql.cfm " > > http://www.houseoffusion.com/lists.cfm/link=m:4:27942:140790 > > Jochem > -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Thanks for the reply. Everything looks good. Yves On Mon, 23 Feb 2004 12:24:33 -0500, Ubqtous <[EMAIL PROTECTED]> wrote: > Yves, > > On 3/1/2004 at 11:53, you wrote: > > YA> I used to following info: > YA> Driver: Other > YA> JDBC URL: jdbc:postgresql://server:port/database > YA> Driver Class: org.postgresql.Driver > > YA> I entered the username and password that I created. I got an > YA> error.. (sorry didn't write it down), it couldn't connect to the > YA> DB. Now, when I tried to modify the info that I entered, I get > YA> this error: "File not found: /datasources/postgresql.cfm " > > YA> Anyone have any suggestions? > > YA> I did look in the datasources folder, and such a file does not > YA> exist... I could see one for Oracle, MySQL but no PostgreSQL. > > The instructions at Jochem's site* worked for me mostly, though I had > to add my PostgreSQL server's port number to the JDBC URL**. Without > the port number, I got that same misleading postgresql.cfm error. > > There was a postgresql.cfm file in MX6.0, but it is apparently not > used in MX6.1 at all; however, there seem to be some references to it > remaining in MX6.1's CF Admin. > > To remove/correct the flawed DSNs, edit > /opt/coldfusionmx/lib/neo-query.xml > > Here's how my RH 9/MX 6.1/PostgreSQL 7.3.4 JDBC URL's are formatted: > > jdbc:postgresql://127.0.0.1:[PostgreSQL port number]/[database] > > (*) http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 > (**) http://jdbc.postgresql.org/doc.html#load (see JDBC URL section) > > Hope that helps! > > ~ Ubqtous ~ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Jochem, On 2/23/2004 at 12:17, you wrote: >> Now, when I tried to modify the info that I entered, I get this >> error: "File not found: /datasources/postgresql.cfm " JvD> http://www.houseoffusion.com/lists.cfm/link=m:4:27942:140790 Great to know! I wonder if this'll be fixed in the next release. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Ubqtous wrote: > On 2/23/2004 at 12:17, you wrote: > > JvD> http://www.houseoffusion.com/lists.cfm/link=m:4:27942:140790 > > Great to know! I wonder if this'll be fixed in the next release. http://www.macromedia.com/go/wish/ But instead of asking them to remove the reference, why not ask them to support PostgreSQL properly? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Jochem, On 2/23/2004 at 14:13, you wrote: JvD> why not ask them to support PostgreSQL properly Is that to say PostgreSQL should be a selectable DBMS when adding a data source? ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Ubqtous wrote: > On 2/23/2004 at 14:13, you wrote: > > JvD> why not ask them to support PostgreSQL properly > > Is that to say PostgreSQL should be a selectable DBMS when adding a > data source? I believe it should be. If you feel the same way, you know where to go :-) Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Jochem, On 2/23/2004 at 14:54, you wrote: JvD> I believe it should be. I assume that would mean having a JDBC driver for PostgreSQL included with the CFMX installation; this driver might need to be updated manually if the version of PostgreSQL being used is out of sync with the driver. JvD> If you feel the same way, you know where to go :-) I do and I do :) ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Ubqtous wrote: > > I assume that would mean having a JDBC driver for PostgreSQL included > with the CFMX installation Yes. > this driver might need to be updated > manually if the version of PostgreSQL being used is out of sync with > the driver. Usually the PostgreSQL JDBC driver and database are compatible 2 major releases in both ways, so that should be pretty rare. And the driver is BSD-licensed, so you can include it in your distribution without any problems. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Jochem, On 2/23/2004 at 15:28, you wrote: JvD> Usually the PostgreSQL JDBC driver and database are compatible 2 JvD> major releases in both ways, so that should be pretty rare. That good to know. Thanks for the feedback! ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Yves Arsenault wrote: > > I entered the username and password that I created. > I got an error.. (sorry didn't write it down), it couldn't connect to the > DB. make sure you have the postmaster service running with the -i option to allow incomming TCP connections, they are turned off by default on PostgreSQL for security reasons. __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Pete, On 2/23/2004 at 16:35, you wrote: PF> make sure you have the postmaster service running with the -i PF> option to allow incomming TCP connections, they are turned off by PF> default on PostgreSQL for security reasons. Now that you mention it, I recall messing with this when I had trouble setting up a DSN, but never actually determined if I needed to allow incoming TCP connections for my set up. Is that necessary if the PostgreSQL server is on the same machine as the CF server? ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Ubqtous wrote: > On 2/23/2004 at 16:35, you wrote: > > PF> make sure you have the postmaster service running with the -i > PF> option to allow incomming TCP connections, they are turned off by > PF> default on PostgreSQL for security reasons. > > Now that you mention it, I recall messing with this when I had trouble > setting up a DSN, but never actually determined if I needed to allow > incoming TCP connections for my set up. Is that necessary if the > PostgreSQL server is on the same machine as the CF server? Yes. PostgreSQL JDBC requires TCP/IP. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Thanks, I discovered that as well shortly after my post.. Works well so far. Yves On Mon, 23 Feb 2004 16:35:53 -0500, Pete Freitag <[EMAIL PROTECTED]> wrote: > Yves Arsenault wrote: > >> >> I entered the username and password that I created. >> I got an error.. (sorry didn't write it down), it couldn't connect to >> the >> DB. > > make sure you have the postmaster service running with the -i option to > allow incomming TCP connections, they are turned off by default on > PostgreSQL for security reasons. > > __ > Pete Freitag > http://www.cfdev.com/ > Author of the CFMX Developers Cookbook > http://www.petefreitag.com/bookshelf/ > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL Sloooooow!
Jillian, It looks like PostgreSQL is struggling because its confused as to exactly what its supposed to be getting from the database. > > This is the query: > > > > > > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > publications.id = 974 > > > > > Put the columns you want to select from content and publications into the select, rather than just saying *. What are you actually trying to get back from the query? (If you want describe what you want from the DB in english and someone nice on the list will turn it into SQL for you) Are you sure you don't mean : SELECT * FROM Content WHERE Content.ID = 974 AND Content.PublicationID = 974 or : SELECT Content.Title, Publication.Title FROM Content LEFT JOIN Publication ON Content.PublicationID = Publication.ID WHERE Content.ID = 947 Don't wrap your CFQUERY in a CFOUTPUT. I'm guessing you're using the comment tags to find out how long the execution time of the query is. Can you not get access to the debug output from CFServer? Hope that helps a bit Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: PostgreSQL Sloooooow!
Jillian, I would say that it's trying to create a pseudo-Cartesian product. That's a fancy way of saying you didn't join your tables in your where clause. The rule of thumb when selecting from multiple tables is that you need at least "n-1" table joins, where n = the number of tables you're querying. So, in your case, you should have a clause in your where statement "content.id = publications.id". The way you're doing it is saying "give me all the data from content where id = 974, and all the data from publications where id = 974, but you're never joining the two tables. So it's going to parse through all this data in each table, and finally generate (probably) the data you want, but that single table join statement in your where clause will likely speed things up. > > This is the query: > > > > > > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > publications.id = 974 > > > > > Lincoln T. Milner Senior Application Programmer/Analyst Department of Health Evaluation Sciences Pennsylvania State University 600 Centerview Drive Suite 2200, A210 Hershey, PA 17033-0855 Ph: 717.531.7178 Fax: 717.531.5779 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: PostgreSQL Sloooooow!
Jillian - You need a join on your table: SELECT * FROM content, publications WHERE content.id = 974 AND content.id = publications.id That will keep the query from retrieving far more data than you actually need - Jim - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 10:00 AM Subject: PostgreSQL Sloow! > Hey everybody! > > I'm working on a site that is selecting a field with a large size... and it > can take on the order of 3-4 seconds whereas the same query executed from > psql > will take under a half a second. > > The query I'm testing with has a text field of size 20466. > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat 7.2. > > This is the query: > > > > > > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > publications.id = 974 > > > > > > There are approximately 1200 records in each table. > > Anybody have any suggestions? Thanks!! > > -- > Jillian Carroll > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: PostgreSQL Sloooooow!
Regarding my previous response... What Lincoln said downqueue :) I should read through ALL the new mails before replying - Jim, cowed - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 10:00 AM Subject: PostgreSQL Sloow! > Hey everybody! > > I'm working on a site that is selecting a field with a large size... and it > can take on the order of 3-4 seconds whereas the same query executed from > psql > will take under a half a second. > > The query I'm testing with has a text field of size 20466. > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat 7.2. > > This is the query: > > > > > > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > publications.id = 974 > > > > > > There are approximately 1200 records in each table. > > Anybody have any suggestions? Thanks!! > > -- > Jillian Carroll > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: PostgreSQL Sloooooow!
I just tried this (based on an earlier suggestion by Stephen/Lincoln)... and it shaved 1-2 seconds off the time. I was at 4 seconds, but now still taking 2-3 seconds. This is LIGHTNING fast on a field with only a few hundred characters. This is screaming driver problem to me. -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 10:54 AM To: CF-Talk Subject: Re: PostgreSQL Sloow! Jillian - You need a join on your table: SELECT * FROM content, publications WHERE content.id = 974 AND content.id = publications.id That will keep the query from retrieving far more data than you actually need - Jim - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 10:00 AM Subject: PostgreSQL Sloow! > Hey everybody! > > I'm working on a site that is selecting a field with a large size... and it > can take on the order of 3-4 seconds whereas the same query executed from > psql > will take under a half a second. > > The query I'm testing with has a text field of size 20466. > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat 7.2. > > This is the query: > > > > > > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > publications.id = 974 > > > > > > There are approximately 1200 records in each table. > > Anybody have any suggestions? Thanks!! > > -- > Jillian Carroll > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: PostgreSQL Sloooooow!
Jillian Carroll wrote: > I'm working on a site that is selecting a field with a large size... > and it can take on the order of 3-4 seconds whereas the same query > executed from psql will take under a half a second. Looks like some transport issue over the wire. Are you running psql on the same machine as CF? Also, half a second seems quite high. Can you provide the EXPLAIN ANALYZE output and possibly the VACUUM FULL content and the VACUUM FULL publications output? For the query, it would be better to use: SELECT * FROM content, publications WHERE content.id = 974 AND publications.id = 974 #cfquery.executiontime# You should also replace the * with the actual fieldnames you want. > There are approximately 1200 records in each table. How many records are you getting back (see CF debugging information)? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: PostgreSQL Sloooooow!
Jillian - a very quick Googling turned up this page: http://cfguru.daemon.com.au/archives/82.html Which may give you some insight to any driver issues, assuming you're using Linux. I'd be interested to hear how it turns out, as I'd like to migrate some CFMX-enabled administrative applications here from MySQL to PostgreSQL for some obvious reasons (transactions, procedures, etc.) Best of luck, - Jim - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 10:55 AM Subject: RE: PostgreSQL Sloow! > I just tried this (based on an earlier suggestion by Stephen/Lincoln)... and > it shaved 1-2 seconds off the time. I was at 4 seconds, but now still > taking 2-3 seconds. > > This is LIGHTNING fast on a field with only a few hundred characters. > > This is screaming driver problem to me. > > -Original Message- > From: Jim Campbell [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 10:54 AM > To: CF-Talk > Subject: Re: PostgreSQL Sloow! > > > Jillian - > > You need a join on your table: > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > content.id = publications.id > > That will keep the query from retrieving far more data than you actually > need > > - Jim > > - Original Message - > From: "Jillian Carroll" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 21, 2002 10:00 AM > Subject: PostgreSQL Sloow! > > > > Hey everybody! > > > > I'm working on a site that is selecting a field with a large size... and > it > > can take on the order of 3-4 seconds whereas the same query executed from > > psql > > will take under a half a second. > > > > The query I'm testing with has a text field of size 20466. > > > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat > 7.2. > > > > This is the query: > > > > > > > > > > > > > > SELECT * > > FROM > > content, publications > > WHERE > > content.id = 974 AND > > publications.id = 974 > > > > > > > > > > > > There are approximately 1200 records in each table. > > > > Anybody have any suggestions? Thanks!! > > > > -- > > Jillian Carroll > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: PostgreSQL Sloooooow!
What did you change the query to? What are you actually trying to get out of the database? Regards Stephen - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 4:55 PM Subject: RE: PostgreSQL Sloow! > I just tried this (based on an earlier suggestion by Stephen/Lincoln)... and > it shaved 1-2 seconds off the time. I was at 4 seconds, but now still > taking 2-3 seconds. > > This is LIGHTNING fast on a field with only a few hundred characters. > > This is screaming driver problem to me. > > -Original Message- > From: Jim Campbell [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 10:54 AM > To: CF-Talk > Subject: Re: PostgreSQL Sloow! > > > Jillian - > > You need a join on your table: > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > content.id = publications.id > > That will keep the query from retrieving far more data than you actually > need > > - Jim > > - Original Message - > From: "Jillian Carroll" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 21, 2002 10:00 AM > Subject: PostgreSQL Sloow! > > > > Hey everybody! > > > > I'm working on a site that is selecting a field with a large size... and > it > > can take on the order of 3-4 seconds whereas the same query executed from > > psql > > will take under a half a second. > > > > The query I'm testing with has a text field of size 20466. > > > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat > 7.2. > > > > This is the query: > > > > > > > > > > > > > > SELECT * > > FROM > > content, publications > > WHERE > > content.id = 974 AND > > publications.id = 974 > > > > > > > > > > > > There are approximately 1200 records in each table. > > > > Anybody have any suggestions? Thanks!! > > > > -- > > Jillian Carroll > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Postgresql setup
Andrew Dixon wrote: > > Can anyone explain or point me in the direction of a web page that > explains how to set-up a Postgresql database with CFMX. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Postgresql setup
Excellent thanks. Andrew. - Original Message - From: Jochem van Dieten <[EMAIL PROTECTED]> Date: Sat, 02 Oct 2004 16:13:32 +0200 Subject: Re: Postgresql setup To: CF-Talk <[EMAIL PROTECTED]> Andrew Dixon wrote: > > Can anyone explain or point me in the direction of a web page that > explains how to set-up a Postgresql database with CFMX. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: PostgreSQL and CFTRANSACTION
Lola Lee wrote: > I have Postgresql 7.4 installed. Have a form and I'm trying to > insert the form contents into several tables in the database. > > Whenever I wrap the queries with the cftransaction tags and I try to > run this insert template, I get the following message: > > > The root cause was that: java.sql.SQLException: ERROR: SET AUTOCOMMIT > TO OFF is no longer supported > Yet, it works when I comment out the cftransaction tags. So, what > does this error message mean? It probably means you have an outdated JDBC driver: http://archives.postgresql.org/pgsql-jdbc/2003-11/msg00184.php Make sure you have at least the the 7.4 driver: http://jdbc.postgresql.org/download.html Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PostgreSQL database size
I checked for query builder in access 2000 and cant seem to find it. How do i access query builder? Phil -Original Message- From: NZERN National Office [mailto:[EMAIL PROTECTED] Sent: Sunday, November 28, 2004 9:06 PM To: CF-Talk Subject: PostgreSQL database size Hi there How large a database can PostgreSQL reliably support. I need something that can store about 100GB Cheers Mike Peters --- NZERN National Office New Zealand Ecological Restoration Network PO Box 9000, Christchurch Ph (03) 338-5451 Fax (03) 338-5481 [EMAIL PROTECTED] www.bush.org.nz ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PostgreSQL database size
You click on the QUERY object, click to create a new query or edit a current query, there's the editor. That what your looking for? -t -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Sunday, November 28, 2004 10:24 PM To: CF-Talk Subject: RE: PostgreSQL database size I checked for query builder in access 2000 and cant seem to find it. How do i access query builder? Phil -Original Message- From: NZERN National Office [mailto:[EMAIL PROTECTED] Sent: Sunday, November 28, 2004 9:06 PM To: CF-Talk Subject: PostgreSQL database size Hi there How large a database can PostgreSQL reliably support. I need something that can store about 100GB Cheers Mike Peters --- NZERN National Office New Zealand Ecological Restoration Network PO Box 9000, Christchurch Ph (03) 338-5451 Fax (03) 338-5481 [EMAIL PROTECTED] www.bush.org.nz ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Perhaps you're looking for testimonials, but according to http://www.postgresql.org/docs/faqs/FAQ.html: 4.5) What is the maximum size for a row, a table, and a database? These are the limits: Maximum size for a database? unlimited (32 TB databases exist) Maximum size for a table?32 TB Maximum size for a row? 1.6TB Maximum size for a field?1 GB Maximum number of rows in a table? unlimited Maximum number of columns in a table?250-1600 depending on column types Maximum number of indexes on a table?unlimited Of course, these are not actually unlimited, but limited to available disk space and memory/swap space. Performance may suffer when these values get unusually large. The maximum table size of 32 TB does not require large file support from the operating system. Large tables are stored as multiple 1 GB files so file system size limits are not important. The maximum table size and maximum number of columns can be quadrupled by increasing the default block size to 32k. On Mon, 29 Nov 2004 15:06:02 +1300, NZERN National Office <[EMAIL PROTECTED]> wrote: > Hi there > > How large a database can PostgreSQL reliably support. I need something that > can store about 100GB -- Ubqtous ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Thanks for your help Ubqtous I have a large 60GB data set of land parcel and related information for NZ which has to be imported from some kind of txt files. One table is apparently 5 GB. The data then needs to be transformed and then accessed via cold fusion on an in house server. I've seen reviews claiming that MySQL and PostgreSQL fall over at the 100GB limit - so kind of curious about the truth in that. I notice that Macromedia don't include PostgreSQL as a supported database fof Coldfusion MX6.1 Server but Bluedragon do. Hmmm curious Mike NZERN -- Original Message -- From: Ubqtous <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 29 Nov 2004 00:15:02 -0500 Perhaps you're looking for testimonials, but according to http://www.postgresql.org/docs/faqs/FAQ.html: 4.5) What is the maximum size for a row, a table, and a database? These are the limits: Maximum size for a database? unlimited (32 TB databases exist) Maximum size for a table?32 TB Maximum size for a row? 1.6TB Maximum size for a field?1 GB Maximum number of rows in a table? unlimited Maximum number of columns in a table?250-1600 depending on column types Maximum number of indexes on a table?unlimited Of course, these are not actually unlimited, but limited to available disk space and memory/swap space. Performance may suffer when these values get unusually large. The maximum table size of 32 TB does not require large file support from the operating system. Large tables are stored as multiple 1 GB files so file system size limits are not important. The maximum table size and maximum number of columns can be quadrupled by increasing the default block size to 32k. On Mon, 29 Nov 2004 15:06:02 +1300, NZERN National Office <[EMAIL PROTECTED]> wrote: > Hi there > > How large a database can PostgreSQL reliably support. I need something that > can store about 100GB -- Ubqtous ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Office wrote: > > I have a large 60GB data set of land parcel and related information for NZ > which has to be imported from some kind of txt files. One table is apparently > 5 GB. The data then needs to be transformed and then accessed via cold fusion > on an in house server. PostgreSQL should be able to handle this without a problem on suitable hardware. Don't forget to check out the PostGIS project, it plugs GIS features right into PostgreSQL. > I've seen reviews claiming that MySQL and PostgreSQL fall over at the 100GB > limit Links? > so kind of curious about the truth in that. There are hundreds of people running terrabyte databases on PostgreSQL. > I notice that Macromedia don't include PostgreSQL as a supported database fof > Coldfusion MX6.1 Server but Bluedragon do. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Jochem van Dieten wrote:
> PostgreSQL should be able to handle this without a problem on
> suitable hardware. Don't forget to check out the PostGIS project,
> it plugs GIS features right into PostgreSQL.
yeah, it's pretty slick. i've been a long-long time user of commercial
GIS database products (mainly arcSDE) and to be able to use cf to run
spatial queries is pretty freaking fantastic:
SELECT provinceName
FROM provinces
WHERE CONTAINS(the_geom, GeometryFromText('POINT(100.65 13.85)')
and to top it off it can output results as SVG.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185508
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Thanks Paul and Jochem
Thats the answer I was hoping for. We have a hosted server running
PostgreSQL/PostGIS/Mapserver running at www.gis.bush.org.nz hosting by
limelyte. But no inhouse experience with even installing PostgreSQL.
We use MSDE2 inhouse but it has a 2GB limit. Being able to integrate CF with
mapserver would be fantastic.
Paul - are you querying ArcSDE with CF directly. ESRI have donated ArcSDE so
where is the boundary between CF and mapserver and flash
Mike
NZERN
-- Original Message --
From: Paul Hastings <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 29 Nov 2004 20:42:05 +0700
Jochem van Dieten wrote:
> PostgreSQL should be able to handle this without a problem on
> suitable hardware. Don't forget to check out the PostGIS project,
> it plugs GIS features right into PostgreSQL.
yeah, it's pretty slick. i've been a long-long time user of commercial
GIS database products (mainly arcSDE) and to be able to use cf to run
spatial queries is pretty freaking fantastic:
SELECT provinceName
FROM provinces
WHERE CONTAINS(the_geom, GeometryFromText('POINT(100.65 13.85)')
and to top it off it can output results as SVG.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185584
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Office wrote: > We use MSDE2 inhouse but it has a 2GB limit. Being able to integrate CF with > mapserver would be fantastic. that's easy enough. we use cf to build url calls & then shoot them at the mapserver CGI using cfhttp. use cf to parse the response (like in the bad old IMS days). long ago we actually built a cfx_mapserver tag but it was flaky (mainly because mapserver itself was not thread safe) & broke other stuff (SDE functionality for instance). > Paul - are you querying ArcSDE with CF directly. ESRI have donated ArcSDE so > not for anything spatial. we're still on arcGIS 8.x. there is no java API for pre-9 arcSDE and frankly i think it wouldn't be as elegant as postGIS's sql. that can go right into cfquery, no fuss, no muss. mind you i don't mind making java calls (that's how we talk to arcIMS) just that having the ability to make a simple sql call to do some spatial work is pretty cool. > where is the boundary between CF and mapserver and flash we haven't used the mapserver/flash functionality much. when we looked at it when it first came out, seemed like we couldn't control very much. if you're getting all that esri s/w for free, why aren't you using arcIMS? i don't like the cfx tag much but the java connector works a treat from mx. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185623 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
very interesting stuff Our issues are to do with history. NZERN has built this working legacy app (2000 pg's spagetti code) and is putting up a cheap to run mapservice using mapserver on another box. ESRI donated all the goodies couple weeks back (SDE, ArcIMS, ArcInfo9 etc) but I figure it will probably take 18 months to get that up on-line and working. The mapserver site will then migrate to ArcIMS. I've seen flash interfaces on ArcIMS and they seem to run much faster than the java stuff. Our main website which is a content management system runs on CF and we are hoping to put up an alternative flash remoting interface on that for users who want it. The CMS will call and insert the maps into the CMS pages both cf and flash. Well thats the idea. Mike -- Original Message -- From: Paul Hastings <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 10:55:43 +0700 Office wrote: > We use MSDE2 inhouse but it has a 2GB limit. Being able to integrate CF with > mapserver would be fantastic. that's easy enough. we use cf to build url calls & then shoot them at the mapserver CGI using cfhttp. use cf to parse the response (like in the bad old IMS days). long ago we actually built a cfx_mapserver tag but it was flaky (mainly because mapserver itself was not thread safe) & broke other stuff (SDE functionality for instance). > Paul - are you querying ArcSDE with CF directly. ESRI have donated ArcSDE so > not for anything spatial. we're still on arcGIS 8.x. there is no java API for pre-9 arcSDE and frankly i think it wouldn't be as elegant as postGIS's sql. that can go right into cfquery, no fuss, no muss. mind you i don't mind making java calls (that's how we talk to arcIMS) just that having the ability to make a simple sql call to do some spatial work is pretty cool. > where is the boundary between CF and mapserver and flash we haven't used the mapserver/flash functionality much. when we looked at it when it first came out, seemed like we couldn't control very much. if you're getting all that esri s/w for free, why aren't you using arcIMS? i don't like the cfx tag much but the java connector works a treat from mx. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
Office wrote: > I've seen flash interfaces on ArcIMS and they seem to run much faster than > the java stuff. Our main website which is a content management system runs on > CF and we are hoping to put up an alternative flash remoting interface on that for users who want it. The CMS will call and insert the maps into the CMS pages both cf and flash. Well thats the idea. i can't see how. backend is still backend, nothing to do w/the user GUI. a flash or html frontend still has to call the arcIMS server for the server to generate an image. unless you're confusing the java client w/the java connector? the java client is a true GIS client, ie it gets the raw data from the server & does stuff with it locally. the java connector is just that, a connector, like the cfx or asp connectors to arcIMS. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL database size
My understanding is (don't have any of these ESRI goodies yet) that an xml call is made to arcIMS giving extant and layers etc. The image returned can then be inserted as a static image on any web page. The CMS has been designed to store a reference to extants and layers. So CF should be able to put a static map image on any page. Mike -- Original Message -- From: Paul Hastings <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 11:38:38 +0700 Office wrote: > I've seen flash interfaces on ArcIMS and they seem to run much faster than > the java stuff. Our main website which is a content management system runs on > CF and we are hoping to put up an alternative flash remoting interface on that for users who want it. The CMS will call and insert the maps into the CMS pages both cf and flash. Well thats the idea. i can't see how. backend is still backend, nothing to do w/the user GUI. a flash or html frontend still has to call the arcIMS server for the server to generate an image. unless you're confusing the java client w/the java connector? the java client is a true GIS client, ie it gets the raw data from the server & does stuff with it locally. the java connector is just that, a connector, like the cfx or asp connectors to arcIMS. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PostgreSQL database size
Mike, Check out the ColdFusion + ArcIMS blog for more information: http://www.mariposa.com.au/arcims/ Cheers, Hugo (we are using CFMX + ArcSDE + ArcIMS ) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Office [mailto:[EMAIL PROTECTED] | Sent: Tuesday, November 30, 2004 06:35 | To: CF-Talk | Subject: Re: PostgreSQL database size | | My understanding is (don't have any of these ESRI goodies | yet) that an xml call is made to arcIMS giving extant and layers etc. | | The image returned can then be inserted as a static image on | any web page. | | The CMS has been designed to store a reference to extants and | layers. So CF should be able to put a static map image on any page. | | Mike | | -- Original Message -- | From: Paul Hastings <[EMAIL PROTECTED]> | Reply-To: [EMAIL PROTECTED] | Date: Tue, 30 Nov 2004 11:38:38 +0700 | | Office wrote: | > I've seen flash interfaces on ArcIMS and they seem to run | much faster | > than the java stuff. Our main website which is a content management | > system runs on CF and we | are hoping to put up an alternative flash remoting interface | on that for users who want it. The CMS will call and insert | the maps into the CMS pages both cf and flash. Well thats the idea. | | i can't see how. backend is still backend, nothing to do | w/the user GUI. | a flash or html frontend still has to call the arcIMS | server for the server to generate an image. unless you're | confusing the java client w/the java connector? the java | client is a true GIS client, ie it gets the raw data from the | server & does stuff with it locally. the java connector is | just that, a connector, like the cfx or asp connectors to arcIMS. | | | | ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PostgreSQL database size
Thanks Hugo a very useful link - I'll read every page. Has anyone used PostgreSQL as the database backend on ArcIMS. I see PostgreSQL is unsupported with ArcSDE with is a real pity IMO. It would be nice to use CFMX + ArcSDE + ArcIMS + PostgreSQL Mike -- Original Message -- From: "Hugo Ahlenius" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 09:37:37 +0100 Mike, Check out the ColdFusion + ArcIMS blog for more information: http://www.mariposa.com.au/arcims/ Cheers, Hugo (we are using CFMX + ArcSDE + ArcIMS ) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Office [mailto:[EMAIL PROTECTED] | Sent: Tuesday, November 30, 2004 06:35 | To: CF-Talk | Subject: Re: PostgreSQL database size | | My understanding is (don't have any of these ESRI goodies | yet) that an xml call is made to arcIMS giving extant and layers etc. | | The image returned can then be inserted as a static image on | any web page. | | The CMS has been designed to store a reference to extants and | layers. So CF should be able to put a static map image on any page. | | Mike | | -- Original Message -- | From: Paul Hastings <[EMAIL PROTECTED]> | Reply-To: [EMAIL PROTECTED] | Date: Tue, 30 Nov 2004 11:38:38 +0700 | | Office wrote: | > I've seen flash interfaces on ArcIMS and they seem to run | much faster | > than the java stuff. Our main website which is a content management | > system runs on CF and we | are hoping to put up an alternative flash remoting interface | on that for users who want it. The CMS will call and insert | the maps into the CMS pages both cf and flash. Well thats the idea. | | i can't see how. backend is still backend, nothing to do | w/the user GUI. | a flash or html frontend still has to call the arcIMS | server for the server to generate an image. unless you're | confusing the java client w/the java connector? the java | client is a true GIS client, ie it gets the raw data from the | server & does stuff with it locally. the java connector is | just that, a connector, like the cfx or asp connectors to arcIMS. | | | | ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL admin GUIs
> I'm just looking into PostgreSQL and am wondering what folks use for and > admin interface? > > I'm looking for favourite Windows or Unix GUIsand bear in mind I am used > to and rather like MS Enterprise Manager for MS SQL Server 2000 ;-) I am far from being a Postgres expert (very far), but I would suggest to try this: http://www.aquadatastudio.com/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: PostgreSQL Sloooooow! - Slightly OT
If you're thinking of bailing on MySQL for another product because of transactions, foreign keys, or something, have a look at MySQL's included InnoDB implementation. From what I read (haven't put it into practice yet), it creates a tablespace where you can do those things regular MySQL can't. But it still is within MySQL. Have a look at the MySQL docs. for more info. I think it's somewhere in Chapter 6. FWIW -lincoln -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 12:06 PM To: CF-Talk Subject: Re: PostgreSQL Sloow! Jillian - a very quick Googling turned up this page: http://cfguru.daemon.com.au/archives/82.html Which may give you some insight to any driver issues, assuming you're using Linux. I'd be interested to hear how it turns out, as I'd like to migrate some CFMX-enabled administrative applications here from MySQL to PostgreSQL for some obvious reasons (transactions, procedures, etc.) Best of luck, - Jim - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 10:55 AM Subject: RE: PostgreSQL Sloow! > I just tried this (based on an earlier suggestion by Stephen/Lincoln)... and > it shaved 1-2 seconds off the time. I was at 4 seconds, but now still > taking 2-3 seconds. > > This is LIGHTNING fast on a field with only a few hundred characters. > > This is screaming driver problem to me. > > -Original Message- > From: Jim Campbell [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 10:54 AM > To: CF-Talk > Subject: Re: PostgreSQL Sloow! > > > Jillian - > > You need a join on your table: > > SELECT * > FROM > content, publications > WHERE > content.id = 974 AND > content.id = publications.id > > That will keep the query from retrieving far more data than you actually > need > > - Jim > > - Original Message - > From: "Jillian Carroll" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 21, 2002 10:00 AM > Subject: PostgreSQL Sloow! > > > > Hey everybody! > > > > I'm working on a site that is selecting a field with a large size... and > it > > can take on the order of 3-4 seconds whereas the same query executed from > > psql > > will take under a half a second. > > > > The query I'm testing with has a text field of size 20466. > > > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat > 7.2. > > > > This is the query: > > > > > > > > > > > > > > SELECT * > > FROM > > content, publications > > WHERE > > content.id = 974 AND > > publications.id = 974 > > > > > > > > > > > > There are approximately 1200 records in each table. > > > > Anybody have any suggestions? Thanks!! > > > > -- > > Jillian Carroll > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: PostgreSQL Sloooooow! - Slightly OT
I'll look into it. Thank you for the tip, I appreciate it. - Jim - Original Message - From: "Lincoln Milner" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 11:09 AM Subject: RE: PostgreSQL Sloow! - Slightly OT > If you're thinking of bailing on MySQL for another product because of transactions, foreign keys, or something, have a look at MySQL's included InnoDB implementation. From what I read (haven't put it into practice yet), it creates a tablespace where you can do those things regular MySQL can't. But it still is within MySQL. > > Have a look at the MySQL docs. for more info. I think it's somewhere in Chapter 6. > > FWIW > -lincoln > > -Original Message- > From: Jim Campbell [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 12:06 PM > To: CF-Talk > Subject: Re: PostgreSQL Sloow! > > > Jillian - > > a very quick Googling turned up this page: > > http://cfguru.daemon.com.au/archives/82.html > > Which may give you some insight to any driver issues, assuming you're using > Linux. I'd be interested to hear how it turns out, as I'd like to migrate > some CFMX-enabled administrative applications here from MySQL to PostgreSQL > for some obvious reasons (transactions, procedures, etc.) > > Best of luck, > > - Jim > > ----- Original Message - > From: "Jillian Carroll" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 21, 2002 10:55 AM > Subject: RE: PostgreSQL Sloow! > > > > I just tried this (based on an earlier suggestion by Stephen/Lincoln)... > and > > it shaved 1-2 seconds off the time. I was at 4 seconds, but now still > > taking 2-3 seconds. > > > > This is LIGHTNING fast on a field with only a few hundred characters. > > > > This is screaming driver problem to me. > > > > -Original Message- > > From: Jim Campbell [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 21, 2002 10:54 AM > > To: CF-Talk > > Subject: Re: PostgreSQL Sloow! > > > > > > Jillian - > > > > You need a join on your table: > > > > SELECT * > > FROM > > content, publications > > WHERE > > content.id = 974 AND > > content.id = publications.id > > > > That will keep the query from retrieving far more data than you actually > > need > > > > - Jim > > > > - Original Message - > > From: "Jillian Carroll" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, November 21, 2002 10:00 AM > > Subject: PostgreSQL Sloow! > > > > > > > Hey everybody! > > > > > > I'm working on a site that is selecting a field with a large size... and > > it > > > can take on the order of 3-4 seconds whereas the same query executed > from > > > psql > > > will take under a half a second. > > > > > > The query I'm testing with has a text field of size 20466. > > > > > > I am running PostgreSQL 7.2 with the latest Unix ODBC driver on Red Hat > > 7.2. > > > > > > This is the query: > > > > > > > > > > > > > > > > > > > > > SELECT * > > > FROM > > > content, publications > > > WHERE > > > content.id = 974 AND > > > publications.id = 974 > > > > > > > > > > > > > > > > > > There are approximately 1200 records in each table. > > > > > > Anybody have any suggestions? Thanks!! > > > > > > -- > > > Jillian Carroll > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: PostgreSQL / MX datasource questions
Josh The following works on the CFMX OS X port (Linux): ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: PostgreSQL / MX datasource questions
CF Data Source Name: arbitraryName JDBC URL: jdbc:postgresql://127.0.0.1/dataBaseName (change 127.0.0.1 to point to your database server, or leave it if the server is local) Driver Class: org.postgresql.Driver Diriver Name: Postgresql Username: xxx (the username you set up with the proper permissions when building and configuring your database) Password: ** Hope this helps. Christian On Thursday, December 26, 2002, at 02:31 PM, Josh wrote: > I can't figure out what to do to get the PostgreSQL JDBC datasources > to work > with CFMX... > > what is an example of the JDBC URL, driver name, and driver class? > These > don't seem to be adequately covered in the documentation. > > Any help would be appreciated. > > Thanks! > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: PostgreSQL / MX datasource questions
Quoting Josh <[EMAIL PROTECTED]>: > > I can't figure out what to do to get the PostgreSQL JDBC datasources > to work with CFMX... > > what is an example of the JDBC URL, driver name, and driver class? http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=15 > These don't seem to be adequately covered in the documentation. Check the PostgreSQL documentation: http://jdbc.postgresql.org/doc.html Jochem -- Friends don't let friends use table-based layouts. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: PostgreSQL problem and cfqueryparam
That is pretty strange - does setting the "null" attribute on the cfqueryparam help? >From that error message it looks like you're going through the SequeLink drivers - you might want to try using the PostgreSQL JDBC drivers, there's a technote at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18338 that goes over how to set them up. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 February 2005 5:01 a.m. To: CF-Talk Subject: SOT: PostgreSQL problem and cfqueryparam I'm having a strange issue with postgresql... I have a database table containing a field defined as follows: ABSTRACT text not null default '' When I insert data, I use cfqueryparam as follows: And I'm seeing this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket]ERROR: ExecInsert: Fail to add null value in not null attribute abstract This works great in tables defined the same way in MySQL ... I would think that cfqueryparam would be sending an empty string, not a null... The simpler solution is just to allow null values in fields that are not required... but I tend to avoid null values as a general rule (I read somewhere that indices on not null fields are more efficient) - Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PostgreSQL and CFMX (OSX) Problem
Lola Lee wrote: > I'm trying to get the PostgreSQL database which I created on my Mac (I'm using Panther) to work through the datasource I set up in CF (6.1). I'm using Dreamweaver MX (6.0) to create the cfm files. > > There are a couple of tables that I have filled with data and it should be returning data when I have my test page call it. However, I always get this error message: > > Error Executing Database Query. > > ERROR: relation "sweatertype" does not exist What do you get when you run: SELECT * FROM INFORMATION_SCHEMA.tables Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL and CFMX (OSX) Problem
Lola Lee wrote: > Using this: > > > #get_sweatertype.table_schema#, #get_sweatertype.table_name# > > > Here's a partial output of the list: > public, Yarn > public, SweaterType You have defined case-sensitive table names: http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS You should be able to query them as using: SELECT * FROM "SwaterType" But I would recommend dumping your schema, removing the double quotes and restoring. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL and CFMX (OSX) Problem
Lola Lee wrote: > Jochem van Dieten wrote: > >> You have defined case-sensitive table names: >> http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS >> >> You should be able to query them as using: >> >> SELECT * >> FROM "SwaterType" >> >> >> But I would recommend dumping your schema, removing the double >> quotes and restoring. > > Thanks! I would never have thought of this. I looked in the Oreilly manual for PostgreSQL and didn't find any obvious information about schemas. Paper tends to be outdated pretty fast. > So, you mean, deleting the database and creating a new one? And make the tables all lowercase? Just dropping and recreating the tables would suffice. And you don't have to make them lowercase, use whatever case you want but don't use double quotes around identifiers. If you are adventurous, you could also try the following query that should fix this for you, but if you have defined views and triggers there might be side-effects: UPDATE pg_catalog.pg_class SET relname = Lower(relname) WHERE relkind = 'r' Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WRONG POST RE: PostgreSQL database size
sorry i hit the wrong message for reply -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Sunday, November 28, 2004 10:24 PM To: CF-Talk Subject: RE: PostgreSQL database size I checked for query builder in access 2000 and cant seem to find it. How do i access query builder? Phil -Original Message- From: NZERN National Office [mailto:[EMAIL PROTECTED] Sent: Sunday, November 28, 2004 9:06 PM To: CF-Talk Subject: PostgreSQL database size Hi there How large a database can PostgreSQL reliably support. I need something that can store about 100GB Cheers Mike Peters --- NZERN National Office New Zealand Ecological Restoration Network PO Box 9000, Christchurch Ph (03) 338-5451 Fax (03) 338-5481 [EMAIL PROTECTED] www.bush.org.nz ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
