I have Mysql 4.0.14 with MyODBC3.51 and Access97.
I have a query
SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization,
inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM
inquiry_data_simple ORDER BY inquiry_data_simple.organization;
The organization field does
I was wondering if there is an opensource mail server (IMAP, not POP) that would
keep all the messages in a MySQL database, not in a regular file?
Apolinaras Apollo Sinkevicius
-
Visit CARMEL MUSIC ENTERTAINMENT website http://carmelme.com
--
I have moved our database from Access to MySQL, but I did leave same structure.
Problem is that in our business we deal with companies that have multiple
branches so having it like we have now with sub queries and subforms that have
to look up info from 3 tables to give me one record of contact
I have MS Access front end with MySQL back end working in my office. MSAccess
via CrossOver office on Mandrake is horrible. So, I am looking now to probably
go with ERP (or ERP/CRM) software that I can get freely out there. I have no IT
budget, I am the IT budget, so I have to do something. Any
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
-
Visit CARMEL MUSIC ENTERTAINMENT website
list?
Which parts of the process are slow? How does the query perform from the
mysql command line?
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 17:29
To: [EMAIL PROTECTED]
Subject: Need help optimizing query, awfully slow
|inquiries.contact_id|1
What does EXPLAIN SELECT query show? Have you read the chapter in the
manual on optimizing queries? Do you have all the proper indices set
up?
--Michael
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED]
Sent
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via
MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query
type that allows bypass of Access interpretation.
Two Questions:
Is the same query running directly on the linux server thru mysql is
you use the
command-line client alone (connected directly to the server), or is it
just when accessing the database through the ODBC tunnel?
--Michael
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:14 PM
1.2Ghz Pentium, with 1/2Gig of ram, 4.0.14MySQL, RedHat9.0
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
passes everything straight to server without ODBC).
NOTE:
I want to move my Microsoft Access based front end (back end is already on
MySQL/Linux) to PHP. MSAccess does have some forms that have VBscript in the,
but I think I can figure other ways to do that.I am not a wizard with PHP, so I
would interested in finding some open source apps, or something
12 matches
Mail list logo