RE: Speed of DECIMAL
From: Jerry Schwartz [mailto:[EMAIL PROTECTED] What is going slower, INSERT / UPDATES or SELECTS? Complex SELECTs CHAR should make for quite efficient processing, since to a large degree nobody cares what's in there: it just slams the data in, or does a simple byte-by-byte comparison. There is probably hardware support for that kind of operation. Decimal arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling. I am doing the following operations: - Joins based on indexed columns - Division by power of 10 - Substring - LIKE comparisons in the form of decimal_column LIKE 'number%' Is any of these especially slow decimals? How would they work with BIGINT(15) UNSIGNED ZEROFILL? No doubt someone whose internals experience is more recent than mine will chime in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 4:37 AM To: mysql@lists.mysql.com Subject: Speed of DECIMAL Hi, I was hoping to speed up my database operations a bit by changing some colums in my database from CHAR(15) ASCII to DEC(15) UNSIGNED ZEROFILL. I was expecting a speedup as DEC(15) is more compact, and this columns are also part of InnoDB indices. In contrary to my expectations, running my test suit took approximately three times as much time, as before. Could anybody give me a probable reason for this slowdown? Thx ImRe P.S.: Ver 5.0.24a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Speed of DECIMAL
[EMAIL PROTECTED] wrote: From: Jerry Schwartz [mailto:[EMAIL PROTECTED] What is going slower, INSERT / UPDATES or SELECTS? Complex SELECTs CHAR should make for quite efficient processing, since to a large degree nobody cares what's in there: it just slams the data in, or does a simple byte-by-byte comparison. There is probably hardware support for that kind of operation. Decimal arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling. I am doing the following operations: - Joins based on indexed columns Did you change *all* columns involved in the joins? Otherwise you have: decimal joining to char which mysql will need to convert internally to be the same type.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: Order to run ANALYZE, OPTIMIZE and CHECK
I run CHECK commands against all tables nightly. Our dataset is small, so it's quick easy; for large and/or static datasets daily might be impractical. However, if you don't run CHECK regularly, you don't know your data is good, and it's possible you might have corruption for a long time before it's caught. That could mean corrupted backups, and if it goes on long enough, you might not have any good backups at all. I strongly recommend running CHECKs as often as practical. It's not just contributing to your peace of mind, it's verifying that your database is performing properly. Dan On 10/26/06, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Oct 27), wolverine my said: Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the preference order to execute these commands? OPTIMIZE calculates statistics as it rebuilds the table, so there's no need to run an ANALYZE pass after it. You shouldn't ever need to run a CHECK unless your OS or MySQL crashes often. in which case you should be filing bug reports :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: Speed of DECIMAL
I'll second what Chris said, which is that all the joined columns should be of the same type for speed. Also, your substring and LIKE comparisons are going to be problematic, as those are string operations, not numeric, and MySQL is having to convert all the decimal values to strings before comparing them. It works but as you've found can be very slow, since you a) have to convert every row, and b) have to do an unindexed comparison. Dan On 10/27/06, Chris [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: From: Jerry Schwartz [mailto:[EMAIL PROTECTED] What is going slower, INSERT / UPDATES or SELECTS? Complex SELECTs CHAR should make for quite efficient processing, since to a large degree nobody cares what's in there: it just slams the data in, or does a simple byte-by-byte comparison. There is probably hardware support for that kind of operation. Decimal arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling. I am doing the following operations: - Joins based on indexed columns Did you change *all* columns involved in the joins? Otherwise you have: decimal joining to char which mysql will need to convert internally to be the same type.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Losing MySQL 5.0 connection at random on Windows box
10061 means actively refused. Maybe check your event log around the same time to see if mysql died? On 27/10/06, mos [EMAIL PROTECTED] wrote: Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get an error message Can't connect to MySQL server on 'localhost' (10061) Socket error on connect. WSAGetLastError return 10061. Does anyone know what could be causing it? This didn't happen when I ways using MySQL 4.1 Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Speed of DECIMAL
A DECIMAL data type would probably be faster than a CHAR when doing arithmetic, and an integer type would be faster yet. I don't know about JOINs on indexed columns. I also don't know about substring and LIKE operations with DECIMAL types, but they should be a lot faster with CHAR than with integer types. Sorry, that's about as far as I can guess. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 27, 2006 2:10 AM To: 'Jerry Schwartz'; mysql@lists.mysql.com Subject: RE: Speed of DECIMAL From: Jerry Schwartz [mailto:[EMAIL PROTECTED] What is going slower, INSERT / UPDATES or SELECTS? Complex SELECTs CHAR should make for quite efficient processing, since to a large degree nobody cares what's in there: it just slams the data in, or does a simple byte-by-byte comparison. There is probably hardware support for that kind of operation. Decimal arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling. I am doing the following operations: - Joins based on indexed columns - Division by power of 10 - Substring - LIKE comparisons in the form of decimal_column LIKE 'number%' Is any of these especially slow decimals? How would they work with BIGINT(15) UNSIGNED ZEROFILL? No doubt someone whose internals experience is more recent than mine will chime in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 4:37 AM To: mysql@lists.mysql.com Subject: Speed of DECIMAL Hi, I was hoping to speed up my database operations a bit by changing some colums in my database from CHAR(15) ASCII to DEC(15) UNSIGNED ZEROFILL. I was expecting a speedup as DEC(15) is more compact, and this columns are also part of InnoDB indices. In contrary to my expectations, running my test suit took approximately three times as much time, as before. Could anybody give me a probable reason for this slowdown? Thx ImRe P.S.: Ver 5.0.24a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql -e Select Fields Enclosed By and NULL values
Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for RD purposes. Instead of doing a mysqldump of nearly 10G of data, I would like to just select a subset of it and load it into the VMware image. I'm facing a snag with regard to NULL values. I've tried doing $mysql -u user -p -B -e select * from table where colum='X' limit 5 /tmp/test.sql which results in a file of id datetimevarchar A2345NULLABC where the table structure is like this id varchar(12) null datetime null varchar(10) null When I try to insert the data tinto my VMware image, I get lots of errors. One of which is that the NULL values is being treated as s string and I get a warning. if I were to use mysqlselect * into outfile '/tmp/test.sql' from temp_table where id='A2345' I get id datetimevarchar A2345\NABC Note that the NULL is now \N which will be interpreted as NULL and the load data infile will work properly w/o errors. The other way to do it would be to use the fields terminated by, eclosed by etc.. However, based on http://dev.mysql.com/doc/refman/5.0/en/select.html it's said that I should be using this syntax instead [quote] The SELECT ... INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT ... INTO OUTFILE. In that case, you should instead use a command such as mysql -e SELECT ... file_name to generate the file on the client host. [/quote] The problem with the above is that I would get literal NULLs instead of \N and I end up with errors/warnings. Is there such a thing to be able to do fields terminated by/enclosed by etc?? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -e Select Fields Enclosed By and NULL values
Ow Mun Heng wrote: Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for RD purposes. Instead of doing a mysqldump of nearly 10G of data, I would like to just select a subset of it and load it into the VMware image. man mysqldump You will find it supports a where clause. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizer Bug?
On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote: My understanding of what is happening here is this: The 'rows' column of EXPLAIN output is an estimate of how many rows MySQL thinks it will likely have to examine in a table to get your answer. When there's an index, it will hopefully be able to use that to exmaine a small subset of the rows in the table. Problem here is, MySQL thinks it will have to examine 1463 of 1950 rows. At that point (or any point higher than about 30%) MySQL will decide that a table scan may be faster. Hence the decision to not use the d_id index. When you drop the index, MySQL can no longer plan to eliminate any rows using an index, so it knows up front it will have to do a table scan, giving you the 1950 answer for the table with no d_id index. What's probably happening is that you have a large grouping of the 5098 number in your data, based on a quick read of your query. Make sense? I guess that makes sense. It's not very obvious, and arguably wrong, that the type and rows columns in the EXPLAIN output are not necessarily referring to the same scenario. Apparently, type always refers to what /will/ happen, and rows refers to how many rows /might/ be looked at. Thanks. -- David Hillman LiveText, Inc 1.866.LiveText x235
Re: Mysql -e Select Fields Enclosed By and NULL values
On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote: Ow Mun Heng wrote: Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for RD purposes. Instead of doing a mysqldump of nearly 10G of data, I would like to just select a subset of it and load it into the VMware image. man mysqldump You will find it supports a where clause. I really missed that. This works now.. mysqldump database_name drive -u user -ppassword --extended-insert --single-transaction --skip-add-locks -n -t -wtable_name.column_name like'A3747' limit 1 /tmp/test.sql Then use the resultant file and do a $mysql -u user -ppassword database_name /tmp/test.sql Many Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizer Bug?
In the last episode (Oct 27), David Hillman said: On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote: My understanding of what is happening here is this: The 'rows' column of EXPLAIN output is an estimate of how many rows MySQL thinks it will likely have to examine in a table to get your answer. When there's an index, it will hopefully be able to use that to exmaine a small subset of the rows in the table. Problem here is, MySQL thinks it will have to examine 1463 of 1950 rows. At that point (or any point higher than about 30%) MySQL will decide that a table scan may be faster. Hence the decision to not use the d_id index. When you drop the index, MySQL can no longer plan to eliminate any rows using an index, so it knows up front it will have to do a table scan, giving you the 1950 answer for the table with no d_id index. What's probably happening is that you have a large grouping of the 5098 number in your data, based on a quick read of your query. I guess that makes sense. It's not very obvious, and arguably wrong, that the type and rows columns in the EXPLAIN output are not necessarily referring to the same scenario. Apparently, type always refers to what /will/ happen, and rows refers to how many rows /might/ be looked at. MySQL is just giving you as much information as it can without actually running the query. It knows how it will go about running the query (so type is known absolutely), but it doesn't know exactly what it will get (so rows is only a guess). Nothing wrong with that. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
loop through SELECT statement query results in a Trigger
Is there a way to loop through individual query records within a stored procedure or trigger. If I have table called client_names (id SERIAL, first name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT, properly_trained TEXT) and I have a trigger on it, I'd like to iterate through individual query rows back at another table having a foreign key on pet_id. For example: CREATE TRIGGER update_clients_with_week_assignment_based_on_pet_id_in_pets_table BEFORE INSERT ON client_names FOR EACH ROW BEGIN (SELECT * FROM pets;) label1: LOOP IF (pets row.pet_type) = 4 THEN SET properly_trained = 1; ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END Is this possible. Can you loop through the query results of a SELECT statement in a trigger, function, or procedure. Ferindo
Performance of different length/size datatypes
Hello, Originally I had this long explanation of what I'm doing and why I'm asking this question but I thought I'd just cut to the chase and ask... For a db that doesn't get a lot queries is there much of a performance difference between BLOB and VARCHAR(255)? Thanks, Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizer Bug?
On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote: MySQL is just giving you as much information as it can without actually running the query. It knows how it will go about running the query (so type is known absolutely), but it doesn't know exactly what it will get (so rows is only a guess). Nothing wrong with that. If type is known absolutely, and is ALL, as it was in this case, why would EXPLAIN ever report a rows value less than the number of rows in the table ( as it did here )? At risk of sounding too much like Bill Clinton, what exactly does ALL mean, then? -- David Hillman LiveText, Inc 1.866.LiveText x235
Re: loop through SELECT statement query results in a Trigger
On Fri, 27 Oct 2006, Ferindo Middleton wrote: Is there a way to loop through individual query records within a stored procedure or trigger. If I have table called client_names (id SERIAL, first name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT, properly_trained TEXT) and I have a trigger on it, I'd like to iterate through individual query rows back at another table having a foreign key on pet_id. For example: CREATE TRIGGER update_clients_with_week_assignment_based_on_pet_id_in_pets_table BEFORE INSERT ON client_names FOR EACH ROW BEGIN (SELECT * FROM pets;) label1: LOOP IF (pets row.pet_type) = 4 THEN SET properly_trained = 1; ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END Is this possible. Can you loop through the query results of a SELECT statement in a trigger, function, or procedure. Ferindo Check out the section on cursors: http://dev.mysql.com/doc/refman/5.0/en/cursors.html That allows you to walk over a result set. -w -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance of different length/size datatypes
Chris, it should be noted that a BLOB is binary data, not character data like VARCHAR. BLOBs will act differently in terms of case-sensitivity for example. The TEXT data type might be more what you're looking for. See http://dev.mysql.com/doc/refman/5.0/en/blob.html for some more info on BLOB and TEXT. Hard to say what difference in performance would be like. If database isn't used much, does it matter much? Dan On 10/27/06, Chris W. Parker [EMAIL PROTECTED] wrote: Hello, Originally I had this long explanation of what I'm doing and why I'm asking this question but I thought I'd just cut to the chase and ask... For a db that doesn't get a lot queries is there much of a performance difference between BLOB and VARCHAR(255)? Thanks, Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizer Bug?
In the last episode (Oct 27), David Hillman said: On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote: MySQL is just giving you as much information as it can without actually running the query. It knows how it will go about running the query (so type is known absolutely), but it doesn't know exactly what it will get (so rows is only a guess). Nothing wrong with that. If type is known absolutely, and is ALL, as it was in this case, why would EXPLAIN ever report a rows value less than the number of rows in the table ( as it did here )? That I don't know. If it's an InnoDB table, mysql can't get an accurate count without reading the entire table so it does a couple of random index dives to estimate the size, which means each explain is likely to see a different number. If it's a MyISAM table, it might be a bug. Try duplicating it on 4.1.21 (or preferably 5.0.26) and if it still happens, file a bug. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent: How to decode base64 via mysql V 5.0.x
Hi, Initially i thought it solved the problem but then i realized that the encoding done by PERL and this mysql function is different.I compated and found that the difference is in a new line , in this function the encoded output is all in one line and the same done via PERL via MIME::Base64 module gives in a different line after some same no of characters. Pl. someone give me a sol. to it. I coould have attached the files but the mailing list wont support that. Also pl. forgive mine top posting. -- Regards, Abhishek jain On 10/17/06, Ady Wicaksono [EMAIL PROTECTED] wrote: http://firestuff.org/wordpress/wp-content/uploads/2006/03/base64.sql On 10/17/06, abhishek jain [EMAIL PROTECTED] wrote: Hi, I want to decode base 64 string via mysql . Also i am using aspx .net . Pl. help me. Urgent reply will be appreciated -- Regards, Abhishek jain
Tej Kohli, Software Tej Kohli, Software MYSQL
Tej Kohli, Software http://www.tejkohlifund.com http://www.tej-kohli-foundation.com http://www.tejkohlimagazine.com http://www.tej-kohli-magazine.com http://www.tejkohli-news.com http://www.tejkohlionline.com http://www.tejkohli-online.com http://www.tejkohlitoday.com Today noted entrepreneur and philanthropist, Tej Kohli, announced the establishment of the Kohli Scholarship Fund for underprivileged kids. Mr Kohli has agreed to donate $1M dollars to the scholarship fund and has committed to provided at least an additional $100,000 per quarter for the next 20 years. The fund will be used to provide partial scholarships to underprivileged Central American children who have achieved academic excellence and demonstrated an interest and aptitude in mathematics and computer sciences. Graduating seniors may apply during the 2006-2007 academic year for scholarships to be awarded in their freshman year of college. Any interested student should contact _@ for more information. On a related note, Tej Kohli has been supporting 87 children and taking care of their education for the past 5 years. These are the children of poor families from the Guanacaste province in Costa Rica. Tej Kohli resides in Henley on Thames, England where he lives with his wife and two small children. He is an IIT graduate and is a member of MENSA. Mr. Kohli has business interest in several countries and is a principal in a privately owned gaming group. Sponsors: http://www.mylasikweb.com Boothe Lasik http://www.mylasikweb.com/ Dr William Boothe http://www.mylasikweb.com/ Dr Boothe http://www.mylasikweb.com/ Lasik Boothe http://www.mylasikweb.com/ Boothe http://www.mylasikweb.com/ Boothe Lasik http://www.mylasikweb.com/ Dr William Boothe http://www.mylasikweb.com/ Dr Boothe http://www.mylasikweb.com/ Boothe http://www.mylasikweb.com/ Lasik Boothe http://www.mylasikweb.com/ Boothe Lasik http://mylasikweb.com/lasik.html Dr William Boothe http://mylasikweb.com/lasik.html Dr Boothe http://mylasikweb.com/lasik.html Boothe http://mylasikweb.com/lasik.html Lasik Boothe http://mylasikweb.com/lasik.html Boothe Lasik http://mylasikweb.com/restor.html Dr William Boothe http://mylasikweb.com/restor.html Dr Boothe http://mylasikweb.com/restor.html Boothe http://mylasikweb.com/restor.html Lasik Boothe http://mylasikweb.com/restor.html Boothe Lasik http://mylasikweb.com/technology.html Dr William Boothe http://mylasikweb.com/technology.html William Boothe http://mylasikweb.com/technology.html Boothe http://mylasikweb.com/technology.html Lasik Boothe http://mylasikweb.com/technology.html Boothe Lasik http://mylasikweb.com/about.html.html Dr William Boothe http://mylasikweb.com/about.html.html William Boothe http://mylasikweb.com/about.html.html Boothe http://mylasikweb.com/about.html.html Lasik Boothe http://mylasikweb.com/about.html.html
Glenn Kawesch Dr. Kawesch is the surgical director of Kawesch Lasik-
Glenn Kawesch Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern California's most experienced refractive surgery facilities. We have been specializing in refractive surgery since 1989 and have completed approximately 25,000 procedures. Dr. Kawesch attended medical school at Northwestern University Medical School in Chicago. He performed important research in Ophthalmology at the world famous Jules Stein Eye Institute at UCLA. He performed his internship at UCLA and his Ophthalmology at UC San Diego. http://www.kaweschlaser.com/ http://www.kaweschlaser.com/ http://www.kaweschlaser.com/ http://www.kaweschlaser.com/ 1-888-215-2020 Call today for more information! San Diego Office 4520 Executive Drive San Diego, CA 92121 Los Angeles Office 11600 Wilshire Blvd, Suite 120, Los Angeles, CA 90025 Dr Kawesch Dr Glenn Kawesch Glenn Kawesch Glenn Kawesch Lasik Lasik Kawesch Kawesch Lasik Surgeon Kawesch Eye Surgeon Kawesch Laser Center What Are The Goals Of Lasik Surgery? The goal of LASIK is to reduce or eliminate your dependence on corrective lenses. By improving the uncorrected vision in patients, LASIK allows patients to go about their daily routine and enjoy life without the need for corrective lenses. How Does Lasik Treat Nearsightedness and Farsightedness? Your eye is anesthetized with eye drops (injections are not necessary). We then use a precise motorized instrument called a microkeratome to create a hinged flap of tissue on the center of the cornea. This flap of tissue is lifted back and the excimer laser is used to sculpt a new flatter surface under this flap. For farsightedness, the laser sculpts a new steeper surface. The flap is then replaced and adheres without requiring any stitches. People sit up from their procedure and can see better immediately. What is No-Cut Lasik? At Custom Laser Center, we're happy to also offer Epi-LASIK, the no-cut LASIK eye surgery procedure. The difference between LASIK and Epi-LASIK is that Epi-LASIK involves no blades or alcohol in the procedure. Epi-LASIK is a less abrasive procedure that many find preferable to traditional LASIK eye surgery. With Epi-LASIK eye surgery, available at our Los Angeles and San Diego offices, a doctor can significantly reduce recovery time. Epi-LASIK is especially recommended for those who have extremely sensitive eyes and are concerned with the effects of putting alcohol on their eyes, or having an incision made. Another benefit of Epi-LASIK is that it's an outpatient procedure. Since we numb your eyes with anesthetic drops, there will be no pain, no needles, and no injections. Epi-LASIK takes only seconds, and you'll be able to see right away. What is Wavefront, or Custom Lasik? Corneas are like fingerprints, just as unique and intricate. They have lumps, bumps, ridges and grooves. These shapes create distortions that can't be treated with glasses or contacts. Even some standard LASIK treatments can only correct so much. That's why Custom Laser Center employs a device called a Wavefront Analyzer, which sends multiple parallel beams of light into the eye. These beams get distorted as they bounce through the cornea, off the retina, and back again. These distortions are registered by the analyzer and used to direct the laser specifically to those areas causing them. These distortions are then targeted and corrected, frequently resulting in better than 20/20 vision. To learn more about the latest in refractive surgery and LASIK eye surgery, contact our San Diego or Los Angeles office to schedule your free consultation. Simply click on the link to the right, or call our staff at 888-215-2020. Find out instantly if you qualify for our amazing LASIK financing options. [EMAIL PROTECTED] 1-888-215-2020 San Diego Office 4520 Executive Drive San Diego, CA 92121 Los Angeles Office 11600 Wilshire Blvd, Suite 120, Los Angeles, CA 90025
Inconsistent table rows with information_schema
Hi, just wondering if there a quick way to determine the # of rows in a mysql table. I know I can do a count(*) but that would entail a table scan etc. I found out that I can do the query into the information_schema table, however, I don't get a consistent reading. executing it multiple times, I get multiple numbers. (and no, the table is static already, no updates/deletes etc) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inconsistent table rows with information_schema
On Saturday 28 October 2006 05:34, Ow Mun Heng wrote: Hi, just wondering if there a quick way to determine the # of rows in a mysql table. I know I can do a count(*) but that would entail a table scan etc. I found out that I can do the query into the information_schema table, however, I don't get a consistent reading. executing it multiple times, I get multiple numbers. (and no, the table is static already, no updates/deletes etc) That's a guesstimate if using InnoDB. Works for MyISAM... -- George-Cristian Bîrzan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inconsistent table rows with information_schema
On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote: On Saturday 28 October 2006 05:34, Ow Mun Heng wrote: Hi, just wondering if there a quick way to determine the # of rows in a mysql table. I know I can do a count(*) but that would entail a table scan etc. I found out that I can do the query into the information_schema table, however, I don't get a consistent reading. executing it multiple times, I get multiple numbers. (and no, the table is static already, no updates/deletes etc) That's a guesstimate if using InnoDB. Works for MyISAM... I'm using InnoDB, Thanks for the info then. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]