ÐÐÑÐÑÑÐ, EXPLAIN ANALYZE [select expression] e ÐÐÐÑÐÐÐÐ ÐÐÐÐÑÐÐÐ:)
ÐÐÐÐ ÐÐ-ÐÐÑÐÐ ÑÐ ÐÐÐÐÑ ÐÑÐÐ, ÐÐÐÐÐ Ð ÐÐÑÐ ÑÐ ÐÐÐÐ Ð ÑÐÐÐ ÑÐÐÐ ÑÐÐÐÐÐ ÐÐÐÐÐÑÐ ÐÑÐÐÑÐ ÑÑÑÐÐÐ (Ð ÐÐÐÑÐ ÑÑÑÐÐÐ). ÐÐÑÐÐÑÐÐÑÐ ÐÐ ÑÐÐÐ VACUUM ÐÐÐÐ ÐÐ ÑÑÑÐ ÑÐ ÑÐ ÑÐ ÐÐÐÐÐÐÐ. ÐÐÐÐÑÐÐÐ: ÐÐÐÐ On Wednesday 23 March 2005 13:01, Damyan Ivanov wrote: > Sertys wrote on 23.03.2005 12:52: > > ÐÐÑÐÐÐ ÑÑÐ ÑÐÐÑÐÐÐÑÐÐÐ ÐÐÐÐÐÐ ÑÐÐ Ð > > ÐÐ-crucial ÐÐÐÐ ÐÐÐÐÐ Ð mySQL Ð ÐÐÐ > > ÐÐÑÑÐÐÑÐÐÑÑ ÐÐ ÐÐÐÐÑ. ÐÐÐÐ ÐÐÐÑÐ ÐÐÑÐ > > ÐÐÑÐ ÐÐ ÑÐÑÐÐÐÐÐ Ð ÐÐÐÐÑÐÐ ÐÐ > > pgsql. ÐÑÑÑÐÑÑÑÐÑÐ Ð ÐÑÐÐÑÐÑÐÐ, ÐÐÐÐÐ ÐÐ > > ÑÐÑÐÑÐÐ, ÐÐ ÐÐÐÑÑÐÐÐÐ ÐÐÐÐÐ > > ÐÐÑÐÐ ÐÑÐÐÐÐÐÐÐÑÐÐÐÐÑÑ. ÐÐÑÐ ÐÑ ÑÐÑÑÐ > > ÐÐ 57 ÑÐÐÐ ÐÐ 222 ÐÐÐÐÑÐÐÑÐÐÐ, > > ÐÐÐÑÐ ÐÐ ÑÐÐÑÑÐÐ. Ð ÐÑÐÐÐÑÐ ÑÐÐÐÐÑÐ ÐÐ > > ÐÐÐÐÐÑÑÐÑÐÐ ÐÑÐÐÑÐÑÐÑ. ÐÐÐÐ > > ÑÑÑÐÑÑÐ ÐÐ Ð ÐÐ ÐÑÐÐÑÐÑÑÐ ÐÐÑÐÐÐÑÐ, Ð ÐÐ > > ÐÑÐÐÐÑÐ windows Ð ÑÐ ÐÐÐÑÑÐÐ, > > ÑÐ Ð ÐÑÑÐÐ. Ð ÐÑÐÑÐÐÐ ÑÐÐÐ ÐÐ 160000 ÑÐÐÐ ÐÐ > > ÐÑÐÐÐÐ ÐÐÐÐÐ 2 ÐÐÐÑÑÐ, > > ÐÐÐÑÐ Ð ÐÐÐÐÑÐÐÐÐ ÐÑÐ mysql ÐÐ ÑÐÑÐÐ, Ð ÐÐ > > ÐÐ ÐÐÐÐÑÐÐ ÐÐ ÐÐÐÐÑÑÐÐÐÐÐÑÐ > > ÑÐÑÐÐÐÑ. ÐÑÐÐÑÐ Ð, ÑÐ ÐÐÐÐÐÑÐ ÑÐ ÐÐÐÐÐÐÐ > > ÐÑ MSSQL server Ð ÐÑÐÐ ÐÐÐÐÐÐÐ > > ÐÐÐÐÐÑÐ ÐÐ ÑÐÐÐÐÑÐÑÐ. ÐÑÐÐÐÐÐ performance tips? > > ÐÐÐ ÐÐÑÐ ÐÐ ÐÐÐÑÐÑ ÐÐ ÑÐÐÐÐÑ ÐÐÐÐÐÑÐ? > ÐÐÐÐÑÐ ÐÑ ÐÐÑÐÐÐÑÐ, ÐÐ. ÐÐÐ Ð > select * from accounting; ÐÐÐÐÐÑ ÐÑÐÐ ÐÐ ÐÐÐÐÐÐÐ. > > ÐÑÐÐÐ ÑÐÐÐ postgresql ÐÑÐÐÐ ÐÐÑÑÐÑ 8 ÐÐÐ Windows, > ÐÐÐ ÐÐ ÑÐ ÐÑÐÐ ÐÐÐÑÐÐÐ > cygwin Ð ÑÐÑ ÐÑÐÐ ÐÐ Ð ÑÑÐÐÐ ÐÐÐ Ð ÐÐÐÐÐ. > ÐÑÐÐÑÑÐÐÐ ÑÐ, ÑÐ ÐÑÑÐÐÑ MSSQL > ÐÐÐ Wine :-) > ÐÐÑÑÐÑ 8, ÐÐÐ ÐÐÐÑÐ native build ÐÐ Windows. > > > ÐÐÐ -- --- "ÐÑÐÐÐÑÐ Ð ÐÐÐÐÐÐÑÐÑÐÐ. ÐÑÐÐ ÐÐÑÐÐ ÐÐ ÑÐ ÐÑÑÐÐÑ ÐÐÐÐÐ, ÐÐ ÐÐ ÑÐ ÐÐÐÐÐÑ." *** ÐÐÐ ÐÐ ÐÑÐÐÐÐÑÑÐ ÐÐ ÐÐÑÐÐÑÐ ÐÐ - ÐÐÐÐÐÐÐÐÑÐ ÑÑÐ: http://6lyokavitza.org/mail ============================================================================ A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html ============================================================================