Hi all,
I have got a database in mysql and i need to use the gis and that was in
VFOXPRO.I need to display my data which is mysql on the map which database
is in VFoXPRO.Is there any way to have communication betweeen these two DBs.
Thanks and regards,
venu.
Hi Venu,
I would like to know the OS your using (for mysql server), BTW if
your using window. Try installing the myodbc and configure it so that
vfoxpro can communicate with it.
check this site:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP
At 06:28 PM 5/22/2006,
Alexander Barkov wrote:
Héctor,
Changing various buffer sizes can improve performance significantly,
with key_buffer_size as the first thing to tune.
Also, make sure you are using not debugging version of the server.
Please also take a look in this section of the documentation
for details:
Hi guys!
Ok, I'm closer to beat Rushmore (VFP optimizer) now!
After some reading about MySQL optimization techniques,
here is the summary of what I've done:
1. Add a compound index to the table
2. Use EXPLAIN to check out the query (with GROUP BY on multiple fields)
3. Create the summary table
And
Héctor,
Changing various buffer sizes can improve performance significantly,
with key_buffer_size as the first thing to tune.
Also, make sure you are using not debugging version of the server.
Please also take a look in this section of the documentation
for details:
Chris wrote:
Hmm
It's just occured to me that you're basically copying and entire table from
one place to another. If I recall correctly, FoxPro cheats somewhat in this
situation - it just copies the concerned files!
Which table type are you using (something I should have asked in the
Mojtaba Faridzad wrote:
BUT my experience: try to change the logic of your report not to retrieve
large number of records. user LIMIT to create the reports page by page. this
is the best and even better for the user.
Ok thanks, but how exactly do I change-the-logic of this query:
mysql select
Hi all,
I'm migrating from Visual FoxPro (I'm a newbie).
On a daily basis I need to run this query on a table with a little more
than
5 million records.
+ MS Visual FoxPro 6.0
select tel, telefb, rutaentran, rutasalien, sum(minutos) as minutos from
traf_oper
group by 1, 2, 3, 4 into table
Héctor Villafuerte D. wrote:
Hi all,
I'm migrating from Visual FoxPro (I'm a newbie).
On a daily basis I need to run this query on a table with a little
more than
5 million records.
+ MS Visual FoxPro 6.0
select tel, telefb, rutaentran, rutasalien, sum(minutos) as minutos
from traf_oper
group
?
Regards,
Chris
Indexes? hmmm... I knew those were useful for something :)
In Visual FoxPro I don't use indexes for this table... so I didn't
considered them
necessary in MySQL (now I think I need to get to the basics of RDBMS).
This table I'm talking about is a CDR (call detail record), so
is Rushmore.
Which indexes do you have on the tables in the query?
Regards,
Chris
Indexes? hmmm... I knew those were useful for something :)
In Visual FoxPro I don't use indexes for this table... so I didn't
considered them
necessary in MySQL (now I think I need to get to the basics of RDBMS
Card)
Related links
http://dmoz.org/Computers/Software/Databases/MySQL/Tutorials/
-Original Message-
From: Héctor Villafuerte D. [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 1:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Really slow query (compared with Visual FoxPro
Dan Greene wrote:
Indexes are your friend. Perhaps your best friend (as far as databases go)
---
To give light on your question... you can index any field... if the entries are
distinct, it's called a 'unique index' which are the best kind to use. Otherwise you
As you are selecting all records (no where clause), it will scan the whole table every
time, I believe...
does anyone know if he added the other columns to his index, or had 4 seperate indexes
(one per column) would they be used in this operation?
Ok, I've found the optimization chapter in
-
From: Héctor Villafuerte D.
Sent: Friday, October 24, 2003 12:10 PM
Subject: Really slow query (compared with Visual FoxPro)
Hi all,
I'm migrating from Visual FoxPro (I'm a newbie).
On a daily basis I need to run this query on a table with a little
more
than
5 million records.
+ MS Visual
Hector,
I migrated from Visual FoxPro too. VFP has different style to work with a
table. MySQL gives you some advantage which you don't have it in VFP. for
example, try to connect to the work server from home and run this query. it
will take 5 days to finish it, but still MySQL takes 3 min.s
Sorry, but what did dou mean with 'Are you still using VisualFoxPro...'?
:)
Mensaje citado por: Ruiz González, Jose de Jesus [EMAIL PROTECTED]:
Are you still using VisualFoxPro as the programmig language in your
project?
If so, you can use SQL functions from VisualFoxPro to connect to mySQL
Are you still using VisualFoxPro as the programmig language in your project?
If so, you can use SQL functions from VisualFoxPro to connect to mySQL using
ODBC
Install mySQL (if you have not allready do it )
Then install MyODBC-3.51.06.exe (downloadable from mySQL page)
Create the ODBC bridge to
Hi,
I have to convert a FoxPro project and use MySQL as the database engine.
I've read some documents about FoxPro and MySQL but still I think I am not
ready to start. Specially I don't know how to use SQLSETPROP properly and
the connection in FoxPro should be synchronous or asynchronous. Please
Is there any api that i can use mySql whith Visual FoxPro ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Tengo una base de datos en Mysql pero programando en visual foxpro no me regresa la
informacion
no se, si hay que hacer algo en especial ??
el codigo en que hace la conexion es el sig.
STORE SQLCONNECT('Sipaae') TO db_conec
IF db_conec = 0
= MESSAGEBOX('Falla al Conectarse al
I wish to use MySQL as a backend to a Visual Foxpro 6 client application, has anyone
got any experience of this ? Does it work ?
Regards
Chris.br clear=allhrGet Your Private, Free E-mail from MSN Hotmail at a
href="http://www.hotmail.com"http://www.hotmail.com/a.br/p
Hi Christopher,
I wish to use MySQL as a backend to a Visual Foxpro 6 client application,
has anyone got any experience of this ? Does it work ?
We're using MySQL as backend for our VFP6-Application. It's working with the
MyODBC-Driver but you have to take care about memo-fields and boolean
Thanks for all the advice about using Visual Foxpro 6 with MySQL. I have started to
create my application and have come across a strange problem.
In MySQL i have a field in a table called Address1, it is VARCHAR(40) ... when i
create my view i can run the sql and see the results no problem
Hi, it works very well via MyODBC with either SQLCONNECT(), SQLEXEC() into local
cursors or Remote Views stored in a local VP database.
From: "Christopher Davis" [EMAIL PROTECTED]
To: "mysqllist" [EMAIL PROTECTED]
Subject: Visual Foxpro 6
Date: Thu, 5 Apr 2001 10:01:57
25 matches
Mail list logo