nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 varbuut man parlikt uz fulltext no unique? Link to comment Share on other sites More sharing options...
Aleksejs Posted June 2, 2008 Report Share Posted June 2, 2008 Nu, lai izmantotu MATCH, tev noteikti ir jāuzstāda fulltext... Pamēģini pievienot fulltext indeksu (veco atstāj, gan noderēs). Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 (edited) Kā uzlikt lai viņš izmanto to index, jo tagad tajā explain vairāk nerāda, ka lietotu indexu.. Ātrums nemainījās tāpat.. Edited June 2, 2008 by nekonezinu Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 http://www.mediafire.com/?dcvvybmgsqz te bus tabulas exports .. Link to comment Share on other sites More sharing options...
bubu Posted June 2, 2008 Report Share Posted June 2, 2008 nekonezinu: tu tiešām neuzskati, ka tev sen jau būtu laiks iet palasīt MySQL manuāli par indeksiem un to pielietošanu? Citādi kautkā muļķīgi sanāk - kautkāda random kverijus un indeksus tu tur veido, cerēdams, ka viss ātri strādās... Link to comment Share on other sites More sharing options...
Aleksejs Posted June 2, 2008 Report Share Posted June 2, 2008 Ieimportēju visu. man izpildās vienlīdz ātri gan uz dvdrip, gan Latvia, gan Antarctica. Varbūt izveido indeksus pa jaunu... Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 Neko nemainīji tabulā? Kāda kverija!? Link to comment Share on other sites More sharing options...
Aleksejs Posted June 2, 2008 Report Share Posted June 2, 2008 Nē, neko nemainīju tabulā un indeksos. SELECT * FROM vardi WHERE vards LIKE 'Latvia%' Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 Tad tā varētu būt servera vaina?? Link to comment Share on other sites More sharing options...
andrisp Posted June 2, 2008 Report Share Posted June 2, 2008 A tu izmeegjinaaji, ko Aleksejs teica ? Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 Uz mana datora ari ātri izpildās, bet uz servera gan nē, uztaisiju uz servera par jaunu indexus, bet tāpat lēni. Varbūt tomēr tad datubāzē kaut kas nepareizi uzstādīts!? Link to comment Share on other sites More sharing options...
Aleksejs Posted June 2, 2008 Report Share Posted June 2, 2008 (edited) hmm... Ieteiktu tad veikt CHECK TABLE vardi un pēc tam iespējams REPAIR TABLE vardi varbūt, ka tabula sabojājusies un tādēļ tāda bremze. [edit]Patiesībā - labāk pats izpēti: http://dev.mysql.com/doc/refman/5.1/en/check-table.html http://dev.mysql.com/doc/refman/5.1/en/tab...aintenance.html http://dev.mysql.com/doc/refman/5.1/en/repair-table.html Edited June 2, 2008 by Aleksejs Link to comment Share on other sites More sharing options...
nekonezinu Posted June 2, 2008 Author Report Share Posted June 2, 2008 ok Link to comment Share on other sites More sharing options...
Paulinjsh Posted June 3, 2008 Report Share Posted June 3, 2008 slinkums skatīties create table, bet kāds table engine ir uzlikts? innodb, myisam cits? Link to comment Share on other sites More sharing options...
nekonezinu Posted June 3, 2008 Author Report Share Posted June 3, 2008 Viss! Paldies visiem! Problēma tika atrisināta! :P Link to comment Share on other sites More sharing options...
Recommended Posts