I'm running MySQL 4.0.13-nt on a Windows XP box, and try to access it
locally thru RDO with myODBC 3.51.

When I try to issue the following statement with RDO from Visual Fox:

sqlexec(nHandle,"SELECT * FROM table1","CursorName")

works fine on any table BELOW 500,000 records, however when I try to
access tables bigger than that, it becomes extremely slow.

But, when I issue the same command from MyAdmin on the same tables, it
works perfect.

Is there any known performance issue regarding table sizes when running on
a local Windows server?

Thanks A Lot for any help!!


Mario Fernando Rodríguez
Highland Systems Xela

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Have you checked the usual suspects, by doing a EXPLAIN on your select?
Also, this reminds me of a situation I experienced where I didn't have an
index on a table: selects were fine up to a certain size (for reasons I have
no fully determined - either because the select results fit in the MySQL
cache but only up to a certain size, or some other optimization such as
default indexes up to a certain size), but past a certain table size,
selects suddenly took ages. In other words: check that you have the right
indices defined.

-----Original Message-----
From: Mario Fernando Rodríguez [mailto:mrodriguez [at] callejondeportivo.com]
Sent: Wednesday, January 19, 2005 2:04 PM
To: myodbc [at] lists.mysql.com
Subject: Performance Degradation


I'm running MySQL 4.0.13-nt on a Windows XP box, and try to access it
locally thru RDO with myODBC 3.51.

When I try to issue the following statement with RDO from Visual Fox:

sqlexec(nHandle,"SELECT * FROM table1","CursorName")

works fine on any table BELOW 500,000 records, however when I try to
access tables bigger than that, it becomes extremely slow.

But, when I issue the same command from MyAdmin on the same tables, it
works perfect.

Is there any known performance issue regarding table sizes when running on
a local Windows server?

Thanks A Lot for any help!!


Mario Fernando Rodríguez
Highland Systems Xela

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=patrickq [at] nyc.rr.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Mario,

You could be going to swap space. Check your memory usage before,
during, and after the execution of the SQL.

Mario Fernando Rodríguez wrote:

>I'm running MySQL 4.0.13-nt on a Windows XP box, and try to access it
>locally thru RDO with myODBC 3.51.
>
>When I try to issue the following statement with RDO from Visual Fox:
>
>sqlexec(nHandle,"SELECT * FROM table1","CursorName")
>
>works fine on any table BELOW 500,000 records, however when I try to
>access tables bigger than that, it becomes extremely slow.
>
>But, when I issue the same command from MyAdmin on the same tables, it
>works perfect.
>
>Is there any known performance issue regarding table sizes when running on
>a local Windows server?
>
>Thanks A Lot for any help!!
>
>
>Mario Fernando Rodríguez
>Highland Systems Xela
>
>
>


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Mario,

You could be going to swap space. Check your memory usage before,
during, and after the execution of the SQL.

Mario Fernando Rodríguez wrote:

>I'm running MySQL 4.0.13-nt on a Windows XP box, and try to access it
>locally thru RDO with myODBC 3.51.
>
>When I try to issue the following statement with RDO from Visual Fox:
>
>sqlexec(nHandle,"SELECT * FROM table1","CursorName")
>
>works fine on any table BELOW 500,000 records, however when I try to
>access tables bigger than that, it becomes extremely slow.
>
>But, when I issue the same command from MyAdmin on the same tables, it
>works perfect.
>
>Is there any known performance issue regarding table sizes when running on
>a local Windows server?
>
>Thanks A Lot for any help!!
>
>
>Mario Fernando Rodríguez
>Highland Systems Xela
>
>
>


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org