Re: Performance question

Am 14.05.2012 23:05, schrieb Nicolas Rannou: > *1* to create 3 tables:* > user - info about a user > images - info about an image > user_image_mapping > > *2* to create 2 tables* > user - info about a user > -> a field would contain a list which represents the ids of the images > the user can

Performance question

Hi all, We are currently designing a database for our application (python/mysql) and we have some performance concern: We would have "users" and "images". "users" can view some "images". "images" can be viewed by several "users". (n to m mapping) Which would be most efficient practice (regarding

Re: performance question

you mail like to find it by your self. simply use : explain re, wh Yong Lee schrieb: All, Just curious as to which query would be better in terms of performance: select * from (select * from a union select * from b) as c; versus select * from a union select * from b; or would these

performance question

All, Just curious as to which query would be better in terms of performance: select * from (select * from a union select * from b) as c; versus select * from a union select * from b; or would these 2 queries be the same ? Thanks, Yong. Yong Lee Developer [EMAIL PROTECTED]

Re: Bulk INSERT performance question

You can also set the bulk_insert_buffer_size=, based on available RAM. This would improve bulk insert on myisam tables. regards anandkl On 7/26/08, mos <[EMAIL PROTECTED]> wrote: > > At 06:46 PM 7/25/2008, you wrote: > >> List, >> >> I am bulk inserting a huge amount of data into a MyISAM table

Re: Bulk INSERT performance question

At 06:46 PM 7/25/2008, you wrote: List, I am bulk inserting a huge amount of data into a MyISAM table (a wikipedia page dump). Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE KEYS; LOCK TABLES page WRITE; The dump consists of about 1,200 bulk INSERT statements with roughly

Bulk INSERT performance question

List, I am bulk inserting a huge amount of data into a MyISAM table (a wikipedia page dump). Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE KEYS; LOCK TABLES page WRITE; The dump consists of about 1,200 bulk INSERT statements with roughly 12,000 tuples each. For the

Re: Re: Performance Question And Problem

At 10:47 PM 11/23/2006, John Kopanas wrote: That is awesome... thanks. I still am not sure exactly though why this take 2 seconds while my methond took over a minute for the same amount of rows. In essence don't the two methods do the same things? No. Your approach was executing the subquery

Re: Re: Performance Question And Problem

At 09:47 PM 11/23/2006, John Kopanas wrote: That is awesome... thanks. I still am not sure exactly though why this take 2 seconds while my methond took over a minute for the same amount of rows. In essence don't the two methods do the same things? The Group By executes in one operation. I may

Re: Re: Performance Question And Problem

That is awesome... thanks. I still am not sure exactly though why this take 2 seconds while my methond took over a minute for the same amount of rows. In essence don't the two methods do the same things? On 11/23/06, mos <[EMAIL PROTECTED]> wrote: At 05:50 PM 11/23/2006, you wrote: >I have the

Re: Performance Question And Problem

In the last episode (Nov 23), John Kopanas said: > I have the following query: > > UPDATE companies c > SET >total_annual_service_charge = > ( >SELECT SUM(annual_service_charge) >FROM purchased_services ps WHERE ps.company_id = c.id > );

Re: Performance Question And Problem

At 05:50 PM 11/23/2006, you wrote: I have the following query: UPDATE companies c SET total_annual_service_charge = ( SELECT SUM(annual_service_charge) FROM purchased_services ps WHERE ps.company_id = c.id ); It takes 1s to run when I ha

Performance Question And Problem

I have the following query: UPDATE companies c SET total_annual_service_charge = ( SELECT SUM(annual_service_charge) FROM purchased_services ps WHERE ps.company_id = c.id ); It takes 1s to run when I have two tables of 500 rows, 4s with t

RE: MySQL Performance Question

inson -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 6:35 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question One reason you might be seeing a higher number of writes than reads is if MySQL is able to answer queries fro

Re: MySQL Performance Question

---Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k tables based on your numbers? MySQL should be able to

RE: MySQL Performance Question

ersions of the application.) --Eric -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k table

Re: MySQL Performance Question

So, you're looking at 150-300 databases and ~31-62k tables based on your numbers? MySQL should be able to handle that, as should your OS, but the most important part IMO is how your clients will be using their data(bases). What sort of queries, how many, etc. Will it be possible for one client to h

MySQL Performance Question

Our server will be home to 50-100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. In terms of performance, is it better to have 1 instance of MySQL servicing multiple databases, or multiple instances of MySQL each serv

RE: MySQL 4.18 Performance Question

Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Shahryar G. Hashemi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 November 2005 8:52 AM To: mysql@lists.mysql.com Subject: MySQL 4.18 Performance

MySQL 4.18 Performance Question

Hello, We are running a MySQL 4.18 database as a read-only snapshot of an internal Sybase database. We have seen an increase in core tables where now we have several million records of data in the MySQL tables. Suddenly the SELECT queries we ran before which took few seconds are now taking m

Re: Union Performance Question

larger ones-generally. Additionally more of the > > >key_buffer can be used for tables with the most hits over the tables > > >with less hits, making the lookup sustain speed over time. > > > > > > > > > > > > > > > > > >>--

RE: Union Performance Question

rally. Additionally more of the > >key_buffer can be used for tables with the most hits over the tables > >with less hits, making the lookup sustain speed over time. > > > > > > > > > > > >>-Original Message- > >>From: Dan Salzer

Re: Union Performance Question

ss hits, making the lookup sustain speed over time. -Original Message- From: Dan Salzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Union Performance Question Hi everyone, I have a question regarding the performance of UNION querie

RE: Union Performance Question

Message- > From: Dan Salzer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 11, 2005 11:46 AM > To: mysql@lists.mysql.com > Subject: Union Performance Question > > Hi everyone, > > I have a question regarding the performance of UNION queries: > > I need to do a full

Union Performance Question

Hi everyone, I have a question regarding the performance of UNION queries: I need to do a full-text search against a large number of rows. Is it faster to have one table with 10,000,000 text rows and perform one full-text search. Or, am I better off having 10 smaller more managable tables and per

Re: Performance question

Hello. Usually the CHAR type is fastest, although it wastes more space. >Hi all > > Suppose that I want to create a table with a column named > "DETAILS" that > will contain textual data. Performance-wise, does it matter if I > represent > this column wit

Performance question

Hi all Suppose that I want to create a table with a column named "DETAILS" that will contain textual data. Performance-wise, does it matter if I represent this column with, say, a 200-char varchar or a larger type like text or mediumtext but be sure that only textual data smaller than 200 chars

Re: Join and Performance Question

Ronan Lucio wrote: Hi, Supposing we have for tables: One master table (student) and three independent tables. There is no relationship between them. Each of the three table have a relationship with table student. City | Teacher | TestLocal | === | = city_id | teac_

Join and Performance Question

Hi, Supposing we have for tables: One master table (student) and three independent tables. There is no relationship between them. Each of the three table have a relationship with table student. City | Teacher | TestLocal | === | = city_id | teac_id | test_id cit

Performance question with perl DBI

Hi all, i have a MySQL driven web system that searches a pretty big DB of property info. (10 data tables, about 50,000,000 total rows, average 300 concurrent users) There are actually 2 databases that feed this site, one is meta info, and isnt hit that heavily. Lets call those DB's 'data' and '

Re: DB Design: performance question

Fax to: 06/15/2004 1

DB Design: performance question

Hi everybody, I'm newly subscribed so please be gentle :) I have a design problem whose solution seems to be directly linked to the MySQL way of handling joints. I created a table USER which manages all entities allowed to connect to the system. |---| |---| |PERSON | |C

ZeosDbo Performance question

Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform is a future you believe in this new plataform? Regards. Carlos J Souza >From Brazil -- <>

Re: Performance Question

You may have to increase the size of the table cache, and you will most probably need to do something about ensuring that the mysqld process can open about 1 billion files at the same time. There was a discussion along these lines not so long ago focusing on having massive numbers of tables that

Re: Performance Question

In the last episode (Dec 15), Jeremy Zawodny said: > On Mon, Dec 15, 2003 at 02:31:16PM -0800, Rob Brackett wrote: > > How hard would it be to modify the MySQL code, and what sort of > > performance hits would I take, if I was to try to run a hundred > > thousand MySQL DBs on the same server? Obvi

Re: Performance Question

On Mon, Dec 15, 2003 at 02:31:16PM -0800, Rob Brackett wrote: > How hard would it be to modify the MySQL code, and what sort of > performance hits would I take, if I was to try to run a hundred thousand > MySQL DBs on the same server? Obviously, some tweaks would be necessary > to be able to break

Performance Question

How hard would it be to modify the MySQL code, and what sort of performance hits would I take, if I was to try to run a hundred thousand MySQL DBs on the same server? Obviously, some tweaks would be necessary to be able to break up the directory structure of /var/lib/mysql, and I may be souding un

Re: MySQL SMP performance question

On Thu, Oct 30, 2003 at 03:35:51PM -0500, [EMAIL PROTECTED] wrote: > Hi everyone. > > I've got a web app that I'm getting ready to make public and I'm to > figure out how well MySQL will utilize multiple processors. Has > anyone seen how MySQL would scale from 1 to 8 processors? Is it > even rem

MySQL SMP performance question

Hi everyone. I've got a web app that I'm getting ready to make public and I'm to figure out how well MySQL will utilize multiple processors. Has anyone seen how MySQL would scale from 1 to 8 processors? Is it even remotely close to linear? My dev environment is W2K, but production will run Red Ha

Re: Mysql Performance Question

.21 37.29 > 10:30:00 HK all 35.91 0.00 16.64 47.45 > 10:40:00 HK all 46.26 0.00 22.03 31.72 > 10:50:00 HK all 43.28 0.00 19.37 37.35 > 11:00:00 HK all 35.22 0.00 16.42 48.36 > 11:10:00 HK

Re: Mysql Performance Question

piler :-)) -- except stat() or whatever to check the mtime. Matt - Original Message - From: "mos" Sent: Wednesday, October 22, 2003 1:44 PM Subject: Re: Mysql Performance Question > At 12:32 PM 10/21/2003, you wrote: > >Thanks a lot guys. > > > >Haydies: &g

Re: Mysql Performance Question

At 12:32 PM 10/21/2003, you wrote: Thanks a lot guys. Haydies: >Just out of wondering, are you using PHP and if so do you use mysql_pconnect >rather then mysql_connect because that would really speed things up. I tired pconnect before but it didn't help but using up all the available memory.

Re: Mysql Performance Question

ECTED]> To: "Rainer Sip" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 3:11 AM Subject: Re: Mysql Performance Question > You need to figure out what's slowing down your application. It could be > expensive queries which in turn could be c

Re: Mysql Performance Question

tive-timeout Hope that helps. Matt > - Original Message - > From: "Rainer Sip" > Sent: Tuesday, October 21, 2003 9:48 AM > Subject: Mysql Performance Question > > > I'm running a community site (Xoops) on Mysql 4.0.14. > > I found that the s

Re: Mysql Performance Question

m Hope that helps, David - Original Message - From: "Rainer Sip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 9:48 AM Subject: Mysql Performance Question I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed

Re: Mysql Performance Question

Rainer Sip wrote: > > I'm running a community site (Xoops) on Mysql 4.0.14. > > I found that the speed of my site is slow during peak hours, when there are 450 > concurrent uers hanging on the site. Mytop showed that the queries per second maxed > at 500. I believe this could be higher, provide

Re: Mysql Performance Question

"Rainer Sip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 5:48 PM Subject: Mysql Performance Question I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurren

Re: Mysql Performance Question

On Wed, 22 Oct 2003 00:48:29 +0800, Rainer Sip <[EMAIL PROTECTED]> wrote: In the mid run I'm planning to mirgrate to innodb for higher concurrency (I'm currently using myisam). However, I'm seeking suggestions in fine tuning the parameters. I know you want to tune the parameters, but if you haven

Re: Mysql Performance Question

On Tuesday, October 21, 2003, at 12:48 PM, Rainer Sip wrote: I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurrent uers hanging on the site. Mytop showed that the queries per second maxed at 500. I belie

Mysql Performance Question

I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurrent uers hanging on the site. Mytop showed that the queries per second maxed at 500. I believe this could be higher, provided that I have it running on a d

performance question: resultset's vs sql

Does anyone know what the relative performance would be of using updateable result sets versus using individual insert or update statements? (Specifically at the moment I'm dealing with JSP programs using J/Connector on Tomcat, if that matters.) For example, if I want to read ten records and up

Re: MySQL tables performance question

If you are going to be needing to add columns and/or tables, you should probably rethink your data model. I'm not sure what data you are tracking, but perhaps you can consolidate it a bit more. Make your columns into rows with a row type field. A simple example would be tracking phone numbers.

MySQL tables performance question

Hello, I have a table where misc data are stored. Right now this table has about 30 columns, but for sure it will be more in the near future. So I wonder how the big number (50-100) of table's columns affect for MySQL DB performance. Maybe it's better to create more tables rather than more table's

Re: MySQL performance question..

"Keith C. Ivey" <[EMAIL PROTECTED]> wrote: >> I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline >> burst, with a wd 512MB HD and I want to store George Bush in our MySQL >> database. >> >> As far as table definitions are concerned, should I use a BLOB or >> should I store him on

Re: MySQL performance question..

On 9 Jul 2003 at 23:14, Andrew Braithwaite wrote: > I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline > burst, with a wd 512MB HD and I want to store George Bush in our MySQL > database. > > As far as table definitions are concerned, should I use a BLOB or > should I store him o

MySQL performance question..

Hi, Can anyone help? I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst, with a wd 512MB HD and I want to store George Bush in our MySQL database. As far as table definitions are concerned, should I use a BLOB or should I store him on disk and make a reference to the physi

Re: Speed Performance Question

Hi Stefan, I haven't ad experience with such a big table yet, but I would like to make a guess. Depending how you use the data (often read, often write, mixed etc.) I would suggest setting up 2 tables. If you use innodb you can distribute the two tables over several disks which should at lea

Speed Performance Question

I am deciding how to setup my MySQL database but i'm having some doubts. I just want to know which is faster, when I query: One table with a double primary key and one search field (3 search conditions) of Two tables with each a single primary and one search field in each table (3 search conditi

Re: full-text performance question

Hi! On Oct 23, Monte Ohrt wrote: > I have a table with a full-text index that spans four text columns. It > seems that the more records a query matches, the longer it takes to > execute. Is that normal? To quote my two-days-ago reply on exactly the same issue: ===

full-text performance question

I have a table with a full-text index that spans four text columns. It seems that the more records a query matches, the longer it takes to execute. Is that normal? Examples: I have 15,376 records in this table: mysql> select count(*) from NS_articles where match(artHeadline,artTagline,artByline,

Re: InnoDB Performance Question.

Jungshu, - Original Message - From: ""Heo, Jungsu"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, October 07, 2002 5:49 AM Subject: InnoDB Performance Question. > Hello everyone. > > I'm working on migrating Oracle to MySQL

Re: Performance Question

> I am writing a serverside application in Java which needs to query/search > 200 000 rows and update affected records once every 2 minutes. > As performance/speed is of importance here - and this Table only contains > 5-10 Columns of Integer numbers, I figured that using a HEAP type of table >

RE: RES: Performance Question.

> Don't forget that MySQL is the fastest thing on the planet for your (and mine) > kind of simple query and insert/updates. We measured 12 times faster > performance in MySQL than Oracle in one part of our application, and I > strongly believe that in the MySQL case the Java program overhead becam

Re: RES: Performance Question.

On Monday 07 October 2002 11:32, Robert H.R. Restad wrote: > Thanks for doing the test :) Don't forget that MySQL is the fastest thing on the planet for your (and mine) kind of simple query and insert/updates. We measured 12 times faster performance in MySQL than Oracle in one part of our appli

RE: Performance Question.

> Thats a pretty nifty speed. PHP have a considerable overhead compared to new > versions of Java. (I use both languages... I prefer PHP for webpage > generation, but Java for serverside applications) And both have a significantly larger overhead than C. Have you tried Escapade? It's a simple,

RE: Performance Question.

> I am hesitant to dig into C++ just to solve this problem, so I am as far as > possible trying to solve the performance issues within Java and MySQL. I > will probably rewrite the code countless of times just to see if I can do > it, and last resort would be C++. Why dig into C++? MySQL has a p

RES: Performance Question.

lto:[EMAIL PROTECTED]] Enviada em: domingo, 6 de outubro de 2002 19:26 Para: [EMAIL PROTECTED] Assunto: RE: Performance Question. Hi Just did a quick test using phpMyAdmin INSERT INTO `db`.`speedtest` SELECT * FROM `db`.`table1` These are just standard MyISAM tables The query creates about 12

RES: Performance Question.

g the test :) Cheers Rob -Mensagem original- De: Peter Lovatt [mailto:[EMAIL PROTECTED]] Enviada em: domingo, 6 de outubro de 2002 18:57 Para: Robert H.R. Restad; [EMAIL PROTECTED] Assunto: RE: Performance Question. Hi I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can r

InnoDB Performance Question.

Hello everyone. I'm working on migrating Oracle to MySQL 4.0.3 MySQL works on Redhat 7.3 and Pentium 550Mhz with 256 Mb RAM. Our application need Transactions, so I decided to use InnoDB. But, InnoDB is slower than I expected. - mysql> SELEC

RE: Performance Question.

--- -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: 06 October 2002 21:08 To: Peter Lovatt; Robert H.R. Restad; [EMAIL PROTECTED] Subject: RE: Performance Question. > I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / S

RE: Performance Question.

> I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run > queries on datasets of 220,000 > > SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time > than I can count (0.1 sec at a guess) > > The insert/update bit is the bit which will dictate the speed - how

RE: Performance Question.

- From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]] Sent: 06 October 2002 14:36 To: [EMAIL PROTECTED] Subject: Performance Question. I am writing a serverside application in Java which needs to query/search 200 000 rows and update affected records once every 2 minutes. As performance/s

Performance Question.

I am writing a serverside application in Java which needs to query/search 200 000 rows and update affected records once every 2 minutes. As performance/speed is of importance here - and this Table only contains 5-10 Columns of Integer numbers, I figured that using a HEAP type of table would be t

Re: What is going on? Performance question

You might try running queries seperately and check performance to see if it Perl or mySQL mike "Norris, Joseph" wrote: > > I am running mysql and apache on windows 2000. Everything is running > smoothly and then all of the sudden my perl scripts that have been running > just find are

Re: What is going on? Performance question

Perhaps memory utilization issues? Does the box start thrashing? Norris, Joseph wrote: > I am running mysql and apache on windows 2000. Everything is running > smoothly and then all of the sudden my perl scripts that have been running > just find are loading > very very slowly. I am not sure i

What is going on? Performance question

I am running mysql and apache on windows 2000. Everything is running smoothly and then all of the sudden my perl scripts that have been running just find are loading very very slowly. I am not sure if it is mysql, perl, apache or what. These are the same scripts that have been running just fine

Re: Mysql performance question

Good Morning Alexander! Looks like you have tuned your system pretty well. > They are slightly less than 25716, is there any way to check if this upper > limit becoming reached sometimes? sysctl kern.openfiles will tell you how many are open now but there is no way to know if the upper limit i

Re: Mysql performance question

ED] > Subject: Re: Mysql performance question > > Your welcome Alexander! > OK the value for table_cache is 8572 * 3 = 25716 file descriptors, > how big is kern.maxfiles and kern.maxfilesproc? These need to be set > above 26000 to allow all those tables to be opened! I know I have

Re: Mysql performance question

ginal Message - From: "Varshavchick Alexander" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]> Cc: "Simon Green" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 11:31 AM Subject: Re: Mysql performance question &

Re: Mysql performance question

From: Ken Menzel <[EMAIL PROTECTED]> > To: Varshavchick Alexander <[EMAIL PROTECTED]>, > Simon Green <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Mysql performance question > > Hi Simon, >A couple of things, unless you have compiled WITH_LI

Re: Mysql performance question

AIL PROTECTED]> Sent: Tuesday, February 19, 2002 8:30 AM Subject: RE: Mysql performance question > Here is the hardware: > > 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, > Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, > > FreeBSD says wh

RE: Mysql performance question

PROTECTED] > Subject: RE: Mysql performance question > > What disk drive have you got? > We have found that this can help. > > Simon > > -Original Message- > From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 13:14 > To: [EMAIL PR

RE: Mysql performance question

What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the

Mysql performance question

Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100,

Re: Mysql query optimiser performance question (second post)

SixK writes: > - MySql make all joins between tables before extracting the required > rows How do you mean? It can only start returning rows when all tables that are needed have been joined, but of course it doesn't create a temporary table with the product of all tables before it starts to ret

Mysql query optimiser performance question (second post)

Hello, sorry, this is the second post, caue I had no reaction. Just wanted to talk about the MySql Query Optimiser. After having performance problems with some queries, I arrived to thoses conclusions: - The order of joins with constants and column have no effect on the speed of the query - MyS

Re: MySQL Performance Question

On Mon, Oct 22, 2001 at 08:02:49AM +0100, Ronan Minogue wrote: > Jeremy, > > Firstly thank you for the reply. > > On the MySql web site there are benchmark response times provided > for the execution of queries on NT 4. e.g. reading 2,000,000 rows > by index requiring 367 seconds. > > Are you

RE: MySQL Performance Question

- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 21 October 2001 23:52 To: Ronan Minogue Cc: [EMAIL PROTECTED] Subject: Re: MySQL Performance Question On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote: > Dear Sir/Madam. > > I have written a Management Information Sy

Re: MySQL Performance Question

On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote: > Dear Sir/Madam. > > I have written a Management Information System that has a MySQL db > running on a Linux server. There is quite a small number of tables. > However these tables are growing quickly and the queries executed > will

MySQL Performance Question

Dear Sir/Madam. I have written a Management Information System that has a MySQL db running on a Linux server. There is quite a small number of tables. However these tables are growing quickly and the queries executed will require "LEFT OUTER JOIN" between tables. Example: A sample query over 4 t

Re: MYSQL performance question

VVM Ravikumar Sarma Chengalvala wrote: > > Joshua, > > > Comparing Oracle vs. MySQL myisam tables, MySQL will > > save disk space, and provide you with much faster > queries, but you have to be aware of the table > locking issues if you are doing > updates/inserts/deletes mixed > with reads. >

Re: MYSQL performance question

VVM Ravikumar Sarma Chengalvala wrote: > > >>>MySql documentation says that mysql enforces > table level locking if no explicit locking is there.If > I am using non transaction sensitive tables can I go > ahead without providing any explicit locking?I am > using myISAM. Yes. This is how I u

Re: MYSQL performance question

Joshua, > Comparing Oracle vs. MySQL myisam tables, MySQL will > save disk space, and provide you with much faster queries, but you have to be aware of the table locking issues if you are doing updates/inserts/deletes mixed > with reads. >>>MySql documentation says that mysql enforces tabl

Re: MYSQL performance question

I'm currently running MySQL with tables that contain ~10 million rows. Each row has 50 columns and the table has 27 indexes. The data size of what you're describing doesn't seem so big. There are some arithmatics in the MySQL manual on how much disk space is used per row. If the tables you hav

Re: MYSQL performance question

limitation about space and speed according to DBMS featuring. since MySQL still have not full SQL 92 feature (transaction, sub select... I think) make it eat a fewer space than other DBMS (oracle or informix) and it can speed up because it did not need to handle more condition. I did not know

Re: MYSQL performance question

Shane Anderson wrote: > > I would like to know the limitations of Mysql with extremely large tables. I > need to store 20+ million records. Each record would contain only 4-6 fields > and would not be longer than 128 bytes of information. The records could be > divided among several tables, but a

MYSQL performance question

I would like to know the limitations of Mysql with extremely large tables. I need to store 20+ million records. Each record would contain only 4-6 fields and would not be longer than 128 bytes of information. The records could be divided among several tables, but at what size is the performance hi

performance question

I'm very new to mysql. I wonder how good is mysql, and comparing it to MS Access. I know mysql is supposed to be way faster than Access, however, to my surprise, it's not necessary the case. I have a table with 700K records. I issued these 2 queries: Access: select top 30 * from rawdata mysq

Re: Performance question

Raf Geusens writes: > Hi, > > I know I've allready posted this question but it's rather important for my > final work. I'll add some extra information at the bottom. > I've got a question 'bout the number of number of writes a MySQLserver can > handle in a second. I've written a program w

Performance question

Hi, I know I've allready posted this question but it's rather important for my final work. I'll add some extra information at the bottom. I've got a question 'bout the number of number of writes a MySQLserver can handle in a second. I've written a program which contains the following code: ty

  1   2   >