Re: mysql < vs source

In the last episode (Mar 10), Brent Clark said: > Hiya > > I just found that I can run > mysql db -e 'source exporteddbdata.sql' > > The question I would like to ask is. Is there a speed difference between > > mysql db < exporteddbdata.sql > and > mysql db -e 'source exporteddbdata.sql' > (usi

mysql < vs source

Hiya I just found that I can run mysql db -e 'source exporteddbdata.sql' The question I would like to ask is. Is there a speed difference between mysql db < exporteddbdata.sql and mysql db -e 'source exporteddbdata.sql' (using source) Reason im asking is, I got a exported 5.4GB database file,

mySQL vs. NoSQL

You guys hear talk about NoSQL and here's a good article on the topic especially as to how it pertains to mySQL... http://www.linuxjournal.com/article/10770 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: mysql vs postgresql -- is this list accurate?

On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day" wrote: > no, i don't want to start a flame war, i just want some feedback on > a current list of mysql "drawbacks" WRT postgresql. > > in the context of a fully open-source, java based ECM product, there > is a FAQ entry that summarize

mysql vs postgresql -- is this list accurate?

no, i don't want to start a flame war, i just want some feedback on a current list of mysql "drawbacks" WRT postgresql. in the context of a fully open-source, java based ECM product, there is a FAQ entry that summarizes why the developers would prefer their users to use postgresql as opposed

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

On Fri, Jun 19, 2009 at 11:27 AM, Brent Baisley wrote: > It sounds like you want to use spatial indexes, but they only became > available in v4.1 > http://dev.mysql.com/doc/refman/5.0/en/create-index.html > http://dev.mysql.com/doc/refman/5.0/en/using-a-spatial-index.html That "feels" like the rig

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

Peter, On Thu, Jun 18, 2009 at 9:27 PM, Peter Brawley wrote: > For explanation & alternatives see "The unbearable slowness of IN()" at > http://localhost/artful/infotree/queries.php. > you prolly meant to not post a url pointing at your local copy of your website. This works better for most of us

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

Matt, This query is still running half an hour later, with a Time of 2167 and a State of "Sending Data" (according to the mysql process list) SELECT custzip FROM customers WHERE custzip IN ( ... For explanation & alternatives see "The unbearable slowness of IN()" at http://localhost/artful/

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

It sounds like you want to use spatial indexes, but they only became available in v4.1 http://dev.mysql.com/doc/refman/5.0/en/create-index.html http://dev.mysql.com/doc/refman/5.0/en/using-a-spatial-index.html You would need to switch your table type from InnoDB to MyISAM, which is fairly easy wit

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

>> SELECT zip FROM zipcodes WHERE >> degrees(acos(sin(radians(39.0788994))*sin(radians(latitude))+ >> cos(radians(39.0788994))*cos(radians(latitude))*cos(radians(-77.1227036-longitude*60*1.1515 >> < 5 > > Ouch.  You might want to calculate the rectange enclosing your target > distance, add an i

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

In the last episode (Jun 18), Matt Neimeyer said: > I'm converting a PHP app from using Visual FoxPro as the database backend > to using MySQL as the backend. I'm testing on MySQL 4.1.22 on Mac OSX > 10.4. The end application will be deployed cross platform and to both 4.x > and 5.x MySQL servers

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

I often find doing the IN (subquery...) is really slow versus doing a join: SELECT cutzip FROM customers INNER JOIN zipcodes ON customers.zipcode=zipcodes.zip WHERE degrees(acos(sin(radians(39.0788994)) * sin(radians(latitude)) + cos(radians(39.0788994)) * cos(radians(latitude)) * cos(radians(-77.

Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

I'm converting a PHP app from using Visual FoxPro as the database backend to using MySQL as the backend. I'm testing on MySQL 4.1.22 on Mac OSX 10.4. The end application will be deployed cross platform and to both 4.x and 5.x MySQL servers. This query returned 21 records in .27 seconds. SELECT

mysql vs fedora-kde-akonadi Q

Greetings; I'm an absolute newbie at databases. Originally I installed mysql because it was needed by mythtv, and with a lot of help I got that to work, although mythtv itself is yet another story. Then I messed up x and was forced to upgrade from my fedora 8 install to fedora 10. Then I inst

RE: Data Warehousing and MySQL vs PostgreSQL

er into MySQL's partitioning. Cheers - Andrew -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 6:44 PM To: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL On 7/26/07, Andrew Armstrong wrote: > * Table 1: 8

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong wrote: > * Table 1: 80,000,000 rows - 9.5 GB > * Table 2: 1,000,000,000 rows - 8.9 GB > This is a generic star schema design for data warehousing. > I have read that it is better if perhaps partitioning is implemented, where > new data is added to a partiti

RE: Data Warehousing and MySQL vs PostgreSQL

007 10:23 AM To: Andrew Armstrong Cc: 'Wallace Reis'; mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL Wallace is right, Data Warehousing shouldn't delete any data. MySQL isn't as robust as say, Oracle, for partitioning so you need to fudge thing

Re: Data Warehousing and MySQL vs PostgreSQL

after a week, etc. I'm more concerned as to why inserts begin to slow down so much due to the large table size. -Original Message- From: Wallace Reis [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 1:02 AM To: Andrew Armstrong Cc: mysql@lists.mysql.com Subject: Re: Data War

RE: Data Warehousing and MySQL vs PostgreSQL

I'm more concerned as to why inserts begin to slow down so much due to the large table size. -Original Message- From: Wallace Reis [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 1:02 AM To: Andrew Armstrong Cc: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong <[EMAIL PROTECTED]> wrote: Do you have a suggestion to how this should be implemented? Data is aggregated over time and summary rows are created. I think that you didnt design correctly your DW. It should have just one very larger table (the fact table). Data should

RE: Data Warehousing and MySQL vs PostgreSQL

Warehousing and MySQL vs PostgreSQL On 7/26/07, Andrew Armstrong <[EMAIL PROTECTED]> wrote: > > Information is deleted from this DW as well, after every five minutes. > The data being recorded is time sensitive. As data ages, it may be deleted. > Groups of samples are aggrega

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong <[EMAIL PROTECTED]> wrote: Information is deleted from this DW as well, after every five minutes. The data being recorded is time sensitive. As data ages, it may be deleted. Groups of samples are aggregated into a summary/aggregation sample prior to being deleted. I

RE: Data Warehousing and MySQL vs PostgreSQL

: Re: Data Warehousing and MySQL vs PostgreSQL On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote: > Hello, > > > > I am seeking information on best practices with regards to Data Warehousing > and MySQL. I am considering moving to PostgreSQL. > * Table 1: 80,

Re: Data Warehousing and MySQL vs PostgreSQL

On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote: > Hello, > > > > I am seeking information on best practices with regards to Data Warehousing > and MySQL. I am considering moving to PostgreSQL. > * Table 1: 80,000,000 rows - 9.5 GB > * Table 2: 1,000,000,000 rows - 8.9 GB Ju

Data Warehousing and MySQL vs PostgreSQL

Hello, I am seeking information on best practices with regards to Data Warehousing and MySQL. I am considering moving to PostgreSQL. I am currently using MySQL as the database of choice. I am now running into performance issues with regards to large tables. At the moment, I have the fol

Re: PHP/MySQL vs ASP/MSSQL?

Me, too. One thing that's a plus for my clients is to tell them that is will cost them less if I develop in php/mysql as opposed to ASP/MSSQL. Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed to ASP/MSSQL which takes 20. heh Jenifer - Original Message -

Re: PHP/MySQL vs ASP/MSSQL?

I have used both and I prefer php/mysql :-) On 11/4/05, Peter Brawley <[EMAIL PROTECTED]> wrote: > Marc, > > >I've been using ASP for years but I have to work on a bigger project > involving many > >users and data so of course, Access is not an option anymore. Since > it's a project requiring >

Re: PHP/MySQL vs ASP/MSSQL?

Marc, >I've been using ASP for years but I have to work on a bigger project involving many >users and data so of course, Access is not an option anymore. Since it's a project requiring >thousand of files and several applications all linked together, I can't create it once and change >it later.

Re: PHP/MySQL vs ASP/MSSQL?

Jigal van Hemert <[EMAIL PROTECTED]> wrote on 11/04/2005 03:09:58 AM: > Marc Pidoux wrote: > > I've been using ASP for years but I have to work on a bigger project > > involving many users and data so of course, Access is not an option > > anymore. Since it's a project requiring thousand of file

Re: PHP/MySQL vs ASP/MSSQL?

Jigal van Hemert wrote: Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). You could always run MySQL on Windows Server along with your IIS and ASP. You don

RE: PHP/MySQL vs ASP/MSSQL?

riginal Message- From: Pooly [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 7:37 AM To: MySQL General Subject: Re: PHP/MySQL vs ASP/MSSQL? 2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>: > I've been using ASP for years but I have to work on a bigger project > inv

Re: PHP/MySQL vs ASP/MSSQL?

2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>: > I've been using ASP for years but I have to work on a bigger project > involving many users and data so of course, Access is not an option > anymore. Since it's a project requiring thousand of files and several > applications all linked together, I can'

Re: PHP/MySQL vs ASP/MSSQL?

Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job.

Re: PHP/MySQL vs ASP/MSSQL?

mysql@lists.mysql.com Subject: Re: PHP/MySQL vs ASP/MSSQL? Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do t

Re: PHP/MySQL vs ASP/MSSQL?

Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. ^^ No flame war intend

Re: PHP/MySQL vs ASP/MSSQL?

Marc Pidoux wrote: I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand of files and several applications all linked together, I can't create it once and change i

PHP/MySQL vs ASP/MSSQL?

I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand of files and several applications all linked together, I can't create it once and change it later. Basically,

Re: MySQL vs Plone/Zope/Python

On Thu, 4 Aug 2005 23:36:01 -0700 (PDT) David Blomstrom <[EMAIL PROTECTED]> wrote: > I wondered if anyone on this list has had experience > with Plone and could explain how their system compares > to PHP/MySQL. I'll be working with animal kingdom data > - child-parent relationships and recursive a

MySQL vs Plone/Zope/Python

I've been experimenting with databases, both Drupal and Plone. Plone is a can of worms, but it's intriguing, partly because it's so different. It sounds like they replace LAMP with something completely different, though it's a complete mystery to me at present. I wondered if anyone on this list ha

Re: MySQL vs XML

Wow, this is turning into quite a research project. Thanks for the tip about ontologies; it doesn't make much sense to me yet, but I'll take a closer look at the article. In the meantime, I'm thinking of using a content management system called Plone. Unfortunately, I've so far been unable to inst

Re: MySQL vs XML

That's an excellent paper. However, David (the OP) is not actually in control, nor is he designing his ontology He is attempting to build a persistence/retrieval system for the taxonomy (ontology) that the scientific community has already created to categorize life on our planet (Kingdom, Phylu

Re: MySQL vs XML

May be you should consider building an ontology with your data base. This links will provides ideas to explore this avenue: http://www.ksl.stanford.edu/people/dlm/papers/ontology-tutorial-noy-mcguinness-abstract.html Raoul David Blomstrom <[EMAIL PROTECTED]> wrote: I've been gathering data for

Re: MySQL vs XML

Thanks for all the tips. That makes it much clearer. I think I'll stick with PHP and MySQL and gradually introduce a little XML if it fits in. I just downloaded a content management system called Plone, which is supposed to be a good choice for hierarchical databases. _

Re: MySQL vs XML

Hi , First of all it should be clear that XML is only a well organised representation of data a mere text file. It is not a software . U will have to append entries all by urself to the file, and marking up suitable tags ( say the attribute of ur relational table) . Data will have to be extracted

Re: MySQL vs XML

MySQL is a relational database. XML is a text file. the biggest difference is that MySQL will let you organize, sort, match/link (joins), and otherwise manipulate the data you have. XML is just text with tags in a heirarchy; anything other than reading it in a text editor will take programming

MySQL vs XML

I've been gathering data for an animal kingdom database for quite some time and am now trying to figure out how to organize and display it. So far, I have a table that lists every order, suborder, family, subfamily, genus and species of mammal in a child-parent relationship, like this: NAME | PARE

Re: MySQL vs. DB2

om: "Rhino" <[EMAIL PROTECTED]> To: "mysql" Sent: Saturday, April 09, 2005 3:28 PM Subject: MySQL vs. DB2 I just came across this comparison of MySQL and DB2. I thought I'd post it here in case anyone was trying to decide between these two products. Please note

Re: MySQL vs. DB2

Oops, sorry, forgot the URL ;-) ftp://ftp.software.ibm.com/software/data/pubs/papers/db2_mysql_comparison.pdf Rhino - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "mysql" Sent: Saturday, April 09, 2005 3:28 PM Subject: MySQL vs. DB2 > I jus

MySQL vs. DB2

I just came across this comparison of MySQL and DB2. I thought I'd post it here in case anyone was trying to decide between these two products. Please note that I am *not* endorsing this comparison. I just want people to be aware of it as one source of information on this subject over and above th

Re: MySQL vs PostgreSQL

On Tue, 15 Mar 2005 18:49:38 +0900 ninjajs <[EMAIL PROTECTED]> wrote: > What do you think about MySQL vs PostgreSQL ? Both are great products and have their ups and downs. On a MySQL list you will not get an un-biases answer to this question. If you really want to know what peop

RE: MySQL vs PostgreSQL

, 15 March 2005 8:20 PM To: mysql@lists.mysql.com Subject: MySQL vs PostgreSQL Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL Gen

MySQL vs PostgreSQL

Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql vs postgresql

Hello. You should search in archives for such questions. For example see threads at: http://lists.mysql.com/mysql/160972 http://lists.mysql.com/mysql/170673 "shabanip" <[EMAIL PROTECTED]> wrote: > hi, > just want to know the main benefits of mysql over postgresql. > thanks,

Re: mysql vs postgresql

On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Don't you think it is childish to link to documentation from 2003? I've never seen a child do anything like you describe. -Rich -- Rich Lafferty --+

Re: mysql vs postgresql

On Fri, 25 Feb 2005 11:21:26 -0600, mos wrote: > > http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html There is a reason this page was removed from the MySQL site: some of it was never correct in the first place, and the rest was severly outdated. Don't you thi

Re: mysql vs postgresql

At 05:45 PM 2/24/2005, you wrote: hi, just want to know the main benefits of mysql over postgresql. thanks, Payam Shabanian Payam, The differences between the products are narrowing, especially with MySQL 5.0 which is still in beta. If I could sum it up in 1 sentence then MySQL is typical

mysql vs postgresql

hi, just want to know the main benefits of mysql over postgresql. thanks, Payam Shabanian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL vs Oracle

10 seconds !?Unless that query is huge and without indexes, it should run MUCH quicker. > I'm using Oracle 8.0.5 and MySQL 4.1.1a > > I'm not optimizing Oracle nor MySQL, because I don't want future users > messing with optimizations. > I access through JDBC drivers. Oracle usually needs 10 se

RE: MySQL vs Oracle

OTECTED] > Sent: Wednesday, June 16, 2004 8:12 AM > To: [EMAIL PROTECTED] > Subject: Re: MySQL vs Oracle > > > I'm using Oracle 8.0.5 and MySQL 4.1.1a > > I'm not optimizing Oracle nor MySQL, because I don't want future users > messing with optimizations

Re: MySQL vs Oracle

age - From: "Weaver, Walt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 16, 2004 4:00 PM Subject: RE: MySQL vs Oracle You didn't provide much information about your system. What version of MySQL? Oracle? With Oracle, which optimizer are you

RE: MySQL vs Oracle

i and 9i at the latest patch levels. Applying the appropriate patches on Oracle can make a big difference too. --Walt > -Original Message- > From: Jaime [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 16, 2004 4:59 AM > To: [EMAIL PROTECTED] > Subject: MySQL vs Oracle > >

MySQL vs Oracle

Hi all! I'm developing a system using both MySQL and Oracle for document processing. I issue a series of queries to the database, depending on the document size. For big documents, both databases behave in the same way but, when using small documents, MySQL finishes quickly while Oracle consume

Re: Query in MySQL vs. PERL

ve no performance issues generating the graphs on the fly with any reasonable timeframe. Anyhow.. Hope that helps a bit. Peter J. Milanese Jack Coxen <[EMAIL PROTECTED]> 04/06/2004 02:01 PM To: "MySQL List (E-mail)" <[EMAIL PROTECTED]> cc:

Query in MySQL vs. PERL

I'm using MySQL to track data throughput information on my company's routers. The routers are queried every 5 minutes 24 hours/day. I need to produce a report showing data accumulated during business hours - Monday through Friday, 8:00-5:00. The program to pull the data and manipulate it will be

Re: MySQl vs 4.1 -- mysqldump

Simon Windsor <[EMAIL PROTECTED]> wrote: > > I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the > output format in mysqldump has changed a lot, using a single insert statement > to populate a table. > > Is there anyway I can use mysqldump to

MySQl vs 4.1 -- mysqldump

Hi I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the output format in mysqldump has changed a lot, using a single insert statement to populate a table. Is there anyway I can use mysqldump to produce a single insert statement for each row? Many thanx Simon -- Simon

Re: mysql vs. MySQL

The real name of the rpm package should be inside the .spec file contained within the rpm file. Best Regards! On Tue, 2004-03-02 at 17:53, David Quenzler wrote: > > > My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base > configuration. > > RPMs are all lower-case of th

mysql vs. MySQL

My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base configuration. RPMs are all lower-case of the form 'mysql, mysql-client, mysql-devel, mysql-shared', etc. Upgrade RPMs are available as MySQL, mixed case, no longer all lower-case. Is this a cosmetic issue only, am I

mysql vs. MySQL

My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base configuration. RPMs are all lowercase of the form 'mysql, mysql-client, mysql-devel, mysql-shared', etc. Upgrade RPMs are available as MySQL, mixed case, no longer all lowercase. Is this a cosmetic issue only, am I a

Re: MySQL vs. MaxDB

avid. - Original Message - From: "Matthew" <[EMAIL PROTECTED]> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 4:18 PM Subject: Re: MySQL vs. MaxDB > > > from http://www.mysql.com/press/release_20

Re: MySQL vs. MaxDB

ggers and views, for the most demanding enterprise use." I know, it's a lazy response. I haven't noticed any performance comparison artiles. - Original Message - From: "Keith Bussey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December

MySQL vs. MaxDB

Hola, I was wondering if anyone could point me to any articles or URLs that could give me an idea of the differences between MaxDB and MySQL, specifically if one were to use MaxDB instead of MySQL, what disadvantages would come with the advantages (which to me are basically some of the features

Re: MySQL vs .NET

really, Delphi to MySQL is just like Delphi to Paradox, > or Oracle or any thing else just get the drivers and off you go :-) > > > - Original Message - > From: "Bill Hess" <[EMAIL PROTECTED]> > To: "William IT" <[EMAIL PROTECTED]> &g

Re: MySQL vs .NET

PROTECTED]> To: "William IT" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 12:56 PM Subject: Re: MySQL vs .NET : If you are using Perl, take a look at SOAP::Lite - do not let the name : fool you... www.soaplite.com Combining this with Apache

Re: MySQL vs .NET

If you are using Perl, take a look at SOAP::Lite - do not let the name fool you... www.soaplite.com Combining this with Apache and mod_perl and given Perl can directly interface with MySQL using Perl's DBI (and also the countless other modules available on CPAN) we have found this to be a v

MySQL vs .NET

I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and also Delphi 8 .Net to provide web services application, I want to know how to make a web services application using Mysql? Or is there similiar technology like .Net but using Mysql? -- MySQL General Mailing List For list

mysql vs mysqlMax

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/d

mysql vs mysqlMax

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/d

Re: MySQL vs. PostgreSQL -- speed test

MySQL has posted a very interesting comparison on their website. It appears to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some areas and MySQL was faster than PostgreSQL in most areas. For speed with all of that functionality, I'd be more inclined to look at DB2 rat

Re: MySQL vs. PostgreSQL -- speed test

Hi! First of all, if I decide to benchmark MySQL vs. PostgreSQL with my application, PostgreSQL will probably be faster. That does not mean that MySQL is "generally" slower or that I *want* it to look slower. That just means 1) I have no experience in tuning MySQL 2) My application

Re: MySQL vs. PostgreSQL -- speed test

> As a minor side issue, we did some _very limited_ testing with MS SQLServer > 2000 using unicode v ascii queries. Using unicode, queries tended to run at > about half the speed compare to using ascii. > This was client server, so it is likely that the increased network traffic > is to blame, but

Re: MySQL vs. PostgreSQL -- speed test

e PostGreSQL. They have a good list and many people their will be more than willing to help you tune your tables. Some of the people on their list are overly sensitive to the MySQL vs. PostGreSQL arguments, but I think most are not. Suggestion (2): If, even with help from their list, you can&#x

Re: MySQL vs. PostgreSql -- speed test

same environment and network conditions, mainly, using IPv6 network protocol. Robson - Original Message - From: "Andy Eastham" <[EMAIL PROTECTED]> To: "Mysql List" <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 2:12 PM Subject: RE: MySQL vs. PostgreSql -- speed

RE: MySQL vs. PostgreSql -- speed test

When I benchmarked PostgreSql against MySql for my application, MySql was 15 times faster, so 18% wouldn't make much difference for me! Andy > -Original Message- > From: Robson Oliveira [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 15:35 > To: [EMAIL PROTECTED] > S

Re: MySQL vs. PostgreSQL -- speed test

>> >I agree with your opinion in 100%, but in my case I need DBMS with >> >features like subselectes/utf-8/stored procedures but the >> speed is also >> >very important issue. >> >> You might have to spend money! >> >> >You are saying that there is DBMS with all this features and it is as >fast as

RE: MySQL vs. PostgreSQL -- speed test

>> >I agree with your opinion in 100%, but in my case I need DBMS with >> >features like subselectes/utf-8/stored procedures but the >> speed is also >> >very important issue. >> >> You might have to spend money! >> >> >You are saying that there is DBMS with all this features and it is as >fast as

RE: MySQL vs. PostgreSQL -- speed test

> >I agree with your opinion in 100%, but in my case I need DBMS with > >features like subselectes/utf-8/stored procedures but the > speed is also > >very important issue. > > You might have to spend money! > > You are saying that there is DBMS with all this features and it is as fast as MySQL

RE: MySQL vs. PostgreSQL -- speed test

>> If maximum speed is critical. >> >> It's easy to lose sight of the fact that speed is not the >> only criterion >> in choosing a DBMS. Features, stability, security, and so on can be >> just as important or more so. No single DBMS is going to win all the >> prizes; the trick is to find th

RE: MySQL vs. PostgreSQL -- speed test

Very smart your opinion, I agree at all with you. -Mensaje original- De: Bruce Feist [mailto:[EMAIL PROTECTED] Enviado el: Monday, July 14, 2003 5:37 AM Para: MySQL List Asunto: Re: MySQL vs. PostgreSQL -- speed test Marek Lewczuk wrote: >For everyone who thinks about moving from My

RE: MySQL vs. PostgreSQL -- speed test

> > which PostgreSQL version have you testet? If you want compare > MySQL and > PostgreSQL, than you have to use InnoDB tables. Tests with > MyISAM make no > sense. Out J2EE Application is working woth PostgreSQL 7.3.3 > and MySQL > 4.0.13 with InnoDB tables (we need transactions and > refe

RE: MySQL vs. PostgreSQL -- speed test

> If maximum speed is critical. > > It's easy to lose sight of the fact that speed is not the > only criterion > in choosing a DBMS. Features, stability, security, and so on can be > just as important or more so. No single DBMS is going to win all the > prizes; the trick is to find the one

Re: MySQL vs. PostgreSQL -- speed test

Marek Lewczuk wrote: For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. That's a bit of an overstatement! Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought

MySQL vs. PostgreSQL -- speed test

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but a

MySQL vs. PostgreSQL recent article?

Hi, Does anybody know of any MySQL vs. PostgreSQL recent article? I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x Thanks in advance, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Linux Mysql vs Windows Mysql

Jeremy Zawodny wrote: Add error checking to all MySQL API calls and the problem will become apparent. Right now you're assuming they all "just work" (except for the mysql_connect()) but they probably don't. I highly recommend anyone using MySQL use either AdoDB

Re: Linux Mysql vs Windows Mysql

On Tue, Jan 14, 2003 at 03:20:20PM -0500, Beauford wrote: > Hi, > > I just installed MySQL and PHP on Windows XP and have a question. I created > a test database on Windows (exactly the same as the test one I use in Linux) > and copied a test PHP script which accesses Mysql and displays some > inf

Linux Mysql vs Windows Mysql

Hi, I just installed MySQL and PHP on Windows XP and have a question. I created a test database on Windows (exactly the same as the test one I use in Linux) and copied a test PHP script which accesses Mysql and displays some information. On Linux it works perfectly, but on Windows I get the follow

MySQL vs. several users same machine

Folks, I have several independent users on one linux machine. They all want to run apps that use mySQL. All of these apps are browser driven. Is there a HOWTO for this situation? Can someone offer guidance? ~~~ Dan 0;-D Austin, TX

mySQL vs. Oracle

We are looking to move to a mySQL db for an application that will possibly process 100's of millions of rows a day and are looking to do it cheaper than an oracle solution. I am new to the mySQL arena and am interested in the groups experience in what mySQL does not do (especially related to backu

mySQL vs. Oracle

Mike, A lot of my Oracle / MySQL questions got answered by searching the archives at for "Oracle" (so many!) or "Oracle ..." e.g "Oracle Backup" etc. Thanks, Sam Bauer, Oracle DBA - Before posting, please check: http://www

  1   2   3   >