Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first edition. Some times i to receive this message but i don't know why.
Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI' (Errcode: 13) The SQL instruction is: alter table products add (unitprice double(7,2), precio2 double(7,2)) I don't know if use MySQL with VB and Windows is good idea. Thanks Carlos >From: "Shashank Tripathi" <[EMAIL PROTECTED]> >To: "'Kyle and Beth Kelly'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> >Subject: RE: Beginner's question >Date: Mon, 15 Jul 2002 09:49:12 +0900 > >Hi Kelly, > > > | I am writting a search engine using Mysql. I am trying to return > | a text object value (which contains all of the html), but it is > | taking about 10 seconds to return each text value matching my >query. > | Is there any way that a text value can be optimized? > > >An SQL query example of what you are doing currently would have been >useful. Are you using '%LIKE%' for "matching"? Or is it taking 10 >seconds for normal selects as well? > >I assume there is a good reason why you are storing the whole HTML in >your database, because it includes a whole bunch of redundant tags, >links etc. Editing your page may become one hell of a chore very soon >(e.g., if you just need to update a link!). > >But anyway, as for the text stuff try the INSTR function >(http://snipurl.com/instr) and see if that helps? Perhaps you could take >a look at regular expressions in some way too >(http://snipurl.com/mysql_regexp) but am not sure how useful that is >unless I know your table structure. > >Meanwhile, you could also try a slightly different approach of having a >separate HTML_SEARCH table which maintains a link to the html blobs in >your current table, but saves ONLY the content (no html tags etc). This >way, the db does not have to search for a whole bunch of redundant tags >but still would have a link to your current html files which are saved >in a separate table that is used only for a layout. > >Hope this helped, >Shanx > > >-- >Shashank Tripathi >www.shanx.com > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
