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
