Hi again.... I'm Working with PB 8.01 , mysql odbc 3.51 driver, Mysql 4.01 alpha-max-nt , OS Platform:w2k service pack2, using INNODB table type
I design a Datawindow using 2 retrieval arguments, in my preview seem to works fine...but when I run my application it doesn't retrieve any data... If I change my datawindow and use only 1 argument works fine.... what could it be???? Also, I have a datawindow that retrieve information from a large tables (40,000 rows ) when I access my SQL my virtual memory runs out and all my system down its performance ....my scrips delays in appear for at least 5 minutes.... I have the server and client in the same machine...and only I have access to the data... I have 128M RAM, and in my.ini set-variable=key_buffer=16M set-variable=sort_buffer=1M when I was using tables with 10 rows I didn't have the problem it started to appered when I filled my tables with a large amount of data..... thanks in advance.... --------------------------------------------------------------------- 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