J
Dear listers,
I try to use PHP, MySql and Apache server to make process data management. I used Access and I had a number of problems of compliance with different
versions of Windows, and also performance. I can't use a database like oracle because of the price . That's why I try with MySql.
I have a problem when I try to read more than 10000 records on a table of 50000 records.
the following command
Select * from table where ident < 10000 ;
gives me the error message:
ERROR 1030: Got error 127 from table handler
I think that the configuration of Mysql does not allow enough memory to answer my request, but I don't find what are the parameters I can change.
thank you for any help
J-F Portala
[email protected]
I try to use PHP, MySql and Apache server to make process data management. I used Access and I had a number of problems of compliance with different
versions of Windows, and also performance. I can't use a database like oracle because of the price . That's why I try with MySql.
I have a problem when I try to read more than 10000 records on a table of 50000 records.
the following command
Select * from table where ident < 10000 ;
gives me the error message:
ERROR 1030: Got error 127 from table handler
I think that the configuration of Mysql does not allow enough memory to answer my request, but I don't find what are the parameters I can change.
thank you for any help
J-F Portala
[email protected]