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,
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'
(using source)
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:
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
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), Robert P. J. Day
rpj...@crashcourse.ca 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
On Fri, Jun 19, 2009 at 11:27 AM, Brent Baisleybrentt...@gmail.com 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
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.
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 index on lat
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
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
Peter,
On Thu, Jun 18, 2009 at 9:27 PM, Peter
Brawleypeter.braw...@earthlink.net 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
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.
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))
*
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
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 partitioned
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: 80,000,000 rows - 9.5 GB
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
Just
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
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
snip
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.
: 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
Warehousing and MySQL vs PostgreSQL
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
snip
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
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 PostgreSQL
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED
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 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
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
things a little. I think partitioning
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
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
@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 the job
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.
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't
-
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
involving many users and data so of course
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
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 files and
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.
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
thousand
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 -
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.
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
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
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,
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
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
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.
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
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 |
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
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
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 mysql@lists.mysql.com
Sent: Saturday, April 09, 2005 3:28 PM
Subject: MySQL vs. DB2
I just came across
Rhino" [EMAIL PROTECTED]
To: "mysql" mysql@lists.mysql.com
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.
P
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]
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 General Mailing
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 people on the MySQL
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
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
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
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,
Payam
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]
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
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
Hi all!
I'm developing a system using both MySQL and Oracle
: 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 using? Oracle, compared to MySQl,
is very tunable
: 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.
I access through JDBC drivers. Oracle usually needs 10
seconds
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
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
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:
Subject:Query in MySQL vs. PERL
I'm using
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
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 produce a single insert statement
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 the
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
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
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_2003_35.html
The MySQL database is a high performance relational database management
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
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 04, 2003 11:25 PM
Subject: MySQL vs. MaxDB
Hola
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
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
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 and mod_perl
: and given Perl can directly interface
:-)
- Original Message -
From: Bill Hess [EMAIL 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
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:
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:
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 was built
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
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
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
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 with
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
referencial
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 MySQL
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 with
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 ?
--
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 ?
I don't
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 ?
I don't
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]
Subject: Re: MySQL vs
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
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]
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
http://php.weblogs.com/adodb
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
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
Mike,
A lot of my Oracle / MySQL questions got answered by searching the
archives at http://
lists.mysql.com/php/search.php for Oracle (so many!) or Oracle ...
e.g Oracle Backup etc.
Thanks,
Sam Bauer, Oracle DBA
-
Before
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
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
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
1 - 100 of 247 matches
Mail list logo
