mysql row limit?

[viveleroi0]

I have MySQL 4.0.21 on windows xp pro with apache 1.3.31 and PHP 4.3.9.

I have a mysql table with 65,500 rows that comes to be 2.7 MB. I have phpMyAdmin 2.6.0-pl2 installed.

When I try to select all rows matching certain criteria, whether in my own php script or using phpMyAdmin, it only seems to scan about a third of those rows.

Most of my queries come back without any results. When I BROWSE using phpmyadmin, I can only see 21 pages at a time. The rest of my tables in the same database only make up about 600KB of data...

I've researched ROW or SPACE limits with MySQL but they seem much higher than 3MB.

I only have five fields, two are INT and three are TEXT.

What could be causing this limitation?

(No I do not use a LIMIT expression in my query).

[tsinka]

Hi,

please post the queries and the table structure.

Thomas

[viveleroi0]

table: nanpa
fields:
ac = INT
pre = INT
state = TEXT
company = TEXT
region = TEXT

SELECT * FROM nanpa WHERE ac="541"

There are 800 rows with the 541 area code but the query will only return results for searches of up to about area code 450. Any area higher than 450 (aka after 20,000 rows) will act as if its not even in the database.

[tsinka]

Ok,

what do these queries return ?

SELECT MAX(ac) FROM nanpa

SELECT COUNT(*) FROM nanpa WHERE ac>'450'

SELECT * FROM nanpa WHERE ac>'450'

Thomas