Problema Ao Fazer Uma Consulta No Microsoft Query

[Renatosky]

Ola amigos,

Estou com um problema ao fazer uma consulta no microsoft sqlquery. Instalei o odbc do mysql e quando eu vou fazer uma pesquisa na minha tabela que possui + de 90.000 (noventa mil) registros ele mostra somente os 4000 (quatro mil) primeiros registros, sera que é alguma limitação do MYSQL?

Se alguém puder me ajudar ficarei agradecido.

[CSML sistemas]

Dá uma olhada nisso...

MySQL 5.0 Reference Manual:

Scalability and Limits:

Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.

Up to 64 indexes per table are allowed (32 before MySQL 4.1.2). Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 1000 bytes (767 for InnoDB); before MySQL 4.1.2, the limit is 500 bytes. An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXT column types.

The maximum effective table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.

Operating System File-size Limit

Win32 w/ FAT/FAT32 2GB/4GB

Win32 w/ NTFS 2TB (possibly larger)

Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)

Linux 2.4+ (using ext3 filesystem) 4TB

Solaris 9/10 16TB

MacOS X w/ HFS+ 2TB

NetWare w/NSS filesystem 8TB

Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. Use NTFS instead.