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, VenuGop
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.
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:
htt
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:
http://www.mysql.com/doc/en/
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
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 te
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
begi
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
al Message -
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
mo
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 i
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
have
u/Quick_Ref/MySQL_QuickRef.pdf (MySQL Quick
Reference 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: [E
rms of a possible advantage 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 n
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).
This table I'm talking about is a CDR (call
Chris
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 tra
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
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 m
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 my
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 g
Hi!
I was using MySQL and Visual FoxPro but I don't know if exists an API to do it
with. I had working with MyODBC and I have no problem at all. With VFP I use to
work with both Remote Views and SQL Pass Throu.
Bye.
:- )
__
José Angel Blanco Linares
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 this
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('F
Is there a way to link FoxPro to MySQL without using ODBC ???
This question is just to satisfy my curiosity, it is not something I need to do.
Regards
Chris.Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com">http://www.hotmail.com.
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
>D
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 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 m
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.Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com">http://www.hotmail.com.
27 matches
Mail list logo
