All, there were many emails posted about this on the MyODBC list which,
of course, can be viewed via the archive on the mysql.com site. For the
most part I will neither quote nor repeat the information from those
emails here.
The conclusion is that MySQL + Merge Tables is perfectly capable of
Hi,
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 2:04 PM
To: MyODBC Mailing List; MySQL List
Subject: RE: MySQL + Access + MyODBC + LARGE Tables
All, there were many emails posted about this on the MyODBC list which,
of course
Spoiler: Venu's Suggestion about Dynamic Cursor is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
MyODBC, as compiled today, uses mysql_store_result to get records. This
is fine for reasonably sized tables. However, if the table has millions
of records, writing the results to a
-Mensaje original-
De: Eugenio Ricart [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 15 de febrero de 2002 7:00
Para: MyODBC Mailing List
Asunto: RE: MySQL + Access + MyODBC + LARGE Tables
Hello,
I work with VB 6.0 ADO 2.5 Access , I am trying work with MySql and the
Last MyODBC
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost related) reasons as to
of this issue but it
didn't hurt to say it (*_*).
I hope this helped at least a little.
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 6:05 PM
To: MySQL List; MyODBC Mailing List
Subject: MySQL + Access + MyODBC + LARGE Tables
Monty, Venu, I
Hi,
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost
Bill,
Some databases can use a live result set when retrieving a lot of
records and I really really wish MySQL could do the same. A live result set
does not create a temporary table or use memory to retrieve all the
records. It will grab 50 or so records at a time, and when scrolling