Your english is understandable so please don't apologize. The way Access/ODBC works during a 'find' operation is that Access will ask the MySQL Server for each record, one at a time, until it finds a match. This is very resource intensive and I try very hard to avoid finding records in this manner. Most of my forms have a custom 'find' function written that applies a filter or changes the recordsource of the form to an appriopriately optimized query. Hope that helps, [EMAIL PROTECTED] -----Original Message----- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 5:56 AM To: mysql Cc: kawa Subject: MySQL dead during an Access/Odbc query Hi! it's the fisrt time im working with mysql+odbc. But i have a small table, only 12.000 items in Access, vinculated with mysql in a linux box. But when i trie to find a item, i push de "find button" in a column, and mysql daemon take 100% of CPU (and more :) and my Access dead. What's wrong? Thanx, and sorry for my poor english. _____ - - - - - - - - - Alejandro Alfonso Fernández - - - - - - - - - /\___/\ Grupo Universitario de Informática - Diplomatura en Estadística /__\ _\/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - /_/\_\ - "Lo mejor de tu ordenador está entre tu silla y tu teclado" - /_/ /\_\ Php Asp WAP SQL Dhtml Flash4 JavaScript Java CGI C Awk Sed Hack \_\/ \_\ - Email: [EMAIL PROTECTED] - Web: http://www.gui.uva.es/~kawa/ -
--------------------------------------------------------------------- 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
