Slow Performance :: Navicat To Import Tables From An ODBC Connection
have been using Navicat to import tables from an ODBC connection I have. The import goes extremely fast but once the data is locally stored and I try to manipulate it by joining tables, the program goes slower and sometimes even crashes it.
If the same data is however imported into a table in MS Access, and a query is created it runs fine. I would like to know if there is a way to improve the performance of my MySQL database as the reason I was using it is because of its scalability. I was wondering if there was something I was doing wrong or could do better.
The Server the data is downloaded to right now is has the following specs:
Windows XP Pro
Intel Core 2 CPU 2.13 Ghz
2 GB RAM
View Complete Forum Thread with Replies
Related Forum Messages:
Connection :: Navicat
I've been using navicat 2004 to connect to a distant MySQL DB for a while. Now i need to connect to it within a vb application but they keep saying i cant. Then i tried with Mysql Administrator 1.2.11 and keep getting : Could not connect to the specified instance MySQL Error Number 1045 Access denied for user :'dbm.prometour.co@207.164.90.59'(Usinf password: YES) How can I connect with Navicat and with everything else I cant?
View Replies !
Remote Connection Navicat
I m trying to connect remotely to mysql on my domain. Navicat works after opening mysql port:3306 on my firewall setting but Mysql query browser gives me the error below. I need to use query browser because navicat is commercial and i only have a trial release. So query browser needs to work for me. Any suggestions on how to sort this out?
View Replies !
How To Delete After Using Navicat In Phpmyadmin/Navicat?
I have converted a xml-file to mysql with Navicat but the problem with the xml-file was that the end of line code wasn't changed before I used Navaicat so I had to look for it manually and change it in there but in Firebug I still saw this code. I have been told that this is characters 13,10 (CR, LF) and is the standard DOS sequence for end-of-line. Now when I try to geocode the adresses from phpmyadmin I got problems and now I need help to search for this code and delete it to my script can geocode the adresses without problem. I could do it manually but the database has about 600 post.
View Replies !
ODBC Connection :: ODBC -- Call Failed
I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL ODBC drivers. Each time I try to connect I get the following error: ***************************** ODBC --call failed. [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130) *****************************
View Replies !
ODBC Connection :: Unable To Create DSN Connection
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
View Replies !
Slow Performance
On my index.php page, I have a simple query that checks the session_id against a table where I store other session_id'. If it's not there, it records it (unique hit). If it's there, it doesn't record it (not a unique hit.) This usually goes off without a hitch, and every month or so I empty the table. Right now I only have about 2500 rows, and it's taking forever to load the page. Is there something possibly server related that could be causing this? My host charges an arm and a leg just to see if there's something wrong if I bring up an issue, so I'd like some insight as to whether there's a commonly known server-side issue that can bog down performance.
View Replies !
Server Performance Slow
I have designed a service on my site which requires about 30 -40 SQL queries per page to run. Everything works without problems apart from the slowness. The page will load very quickly until it gets to the first query, then it pauses..... and carries on slowly producing the results. (When I say slowly, I mean relative slow compared to the speed this forum loads for instance)All the other web apps with mySQL work without slowing down, but they don't take up as much resources. Even the VB board is very fast. I'm running a 2.8Ghz 1GB Win2003 server, so I doubt that is a problem. Is there a guide to optimizing mySQL server or a key "setting" I should be changing?
View Replies !
Slow Performance While Mysqldump
i have a large database with many tables. I was using it fine on HP Proliant server (4gb ram). Now i did the same database to a mirror HP Proliant (2Gb ram). After recovery the database, query is very very slower then Machine 1, does it damage the index while dumping? How do you recover indexes if some way it damage and cause the slow performance? Machine 1: >mysqldump --user=root --password=root -R --ignore-table=database.table0 --ignore-table=database.able1 database > pathsql.sql Machine 2: >mysql --user=root --password=root database < pathsql.sql
View Replies !
Memory Maxed Out And Slow Performance
We have two main query types running against a table of some 2 million rows and have gotten query response down to well under a second by using the right indexes. Problem is that we are running an advertising campaign that brings a concentrated block of users to the site. When this happens one of the queries which relies on a particluar index comes severely of the rails and can take up to 2 minutes filling the slow query log for 15 to 20 minutes. The other query type never appears in the slow log at these times. Can anyone explain why this is happening? The server has 2Gb of ram and a key_buffer of 1Gb. When the problems occur mysql uses all of the key_buffer but the total value of the MYI files is under 250Mb. What is in memory - thread related buffers? It seems as though the index required for the query is not in memory and the disks are coming into play. Why is only one index affected? I would really appreciate some pointers, what can I check to pinpoint the problem and what settings should I implement to preserve performance? Front end is 4 cold fusion web servers using persistent connections. max_connections is currently at 100.
View Replies !
Performance On MySQL 5.1 / ODBC 5.1.4 Driver
Following procedure needs about 25 sec. to find the record I am asking for: Private Sub btnLesen_Click() sSQL = "SELECT * FROM tblAdressen WHERE AdressNr = 8" aRs.CursorLocation = adUseClient aRs.Open sSQL, oConn, adOpenKeyset, adLockOptimistic If aRs.RecordCount > 0 Then sevVorname = aRs!Vorname sevStrasse = aRs!Strasse sevOrt = aRs!Ort sevName = aRs!Nachname End If End Sub There are around 14'000 records in the table, Nr. 8 is the first one! I am trying to find the reason for the bad performance for days - without any success. Following Flags are checked for the connector: - return matched rows instead of affected rows - Allow big results - Use compression - Treat BIGINT columns as INT columns - Enable safe options - Don't prompt when connecting - Enable dynamic cursors - Ignore schema in Column specification - disable driver-provided cursor support - Don't use setlocale() - Don't cach results of forward-only cursors - Ingnore space after function names - Disable catalog support - Disable transaction support - Force use of forward-only cursors - Limit column sizs to signed 32-bit range The file "my.ini" I didn't change! I work with Win2000 & VB 6.0
View Replies !
Slow Performance After Falling Back To MySQL 3
Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and reinstalled everything (it was a sinle Xeon 700). The default RH9 installation comes with MySQL 3.23.54. After the reinstallation I found the machine was not as responsive as before. (It's not very slow, but some lagging is noticed) I was running Mysql-max 4.0.11 and the performance was ok, except the slowness during the peak hours, which was regarded as normal. I would like to know the differences between Mysql 3 and 4. Is the new version making a significant jump in performance? I also noticed the system eats up memory faster than before. With the old setting the system never used up 60% of physical memory, even at extremely high loading (30+). Now it easily used up 70% of memory. Code:
View Replies !
MySQL ODBC 3.51 Driver Very Slow!
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally.
View Replies !
Slow Connection
I build an application and installed it on many machines. In every machine except two, the program works without problems. On this two, the connection with database is too slow. I saw the opened doors with 'netstat' and the computer opens about 5 or 6 ports (to the port 3306 of the mysql server) before sucessfuly connect with MySql Database and execute the sql. I don't know what could be happening. I realy need to fix this because the progrm is too slow with this error. Could anyone know what could be happening??
View Replies !
MySQL Connection Sometimes Slow
I have been developing an application in Visual Basic that accesses a MySQL database either on the local machine, or a remote machine. Locally, database connections run smoothly. However, when I try to connect to the remote system (another computer on my local network) some databases take longer to connect than others (sometimes 10 - 20 seconds). The application usses the myvbql.dll (sorry lost the link, found it through google) wrapper around the libmysql.dll file to perform database actions. The application seems to hang when it tries to actually make the connection to the datatbase. This is only happening on the remote database server, and does not happen on every connection to that server.
View Replies !
Connection :: Pages Slow
we have end site layout (really fast and made with css+xhtml) so we have insert the mysql connection The page load seems very very slow at middle of page. Page is load within middle, after there are pause of 1/2 second and after load continue .. we don't have meet this problem so, we have comment all last row code.. the row that make problem is mysql connection: $conn = mysql_connect($_CONFIG['host'], $_CONFIG['user'], $_CONFIG['pass']) or die('Impossibile stabilire una connessione'); mysql_select_db($_CONFIG['dbname']); Have you any idea?
View Replies !
ODBC Connection Using Access
I am using Access 2K as a front end to MySQL running on a Linux server. I am having trouble connectiong to the server. MySQL control centre connects and I can connect using a DSN data source. But if I connect using the following code: Dim constr As String Dim tbl As DAO.TableDef constr = "ODBC;DRIVER={MySQL ODBC 3.51 Driver};DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME tbl.Connect = constr tbl.SourceTableName = MYTABLENAME DoEvents CurrentDb.TableDefs.Append tbl I get a Cannot find installable ISAM error message when trying to append the table. It appears that a connection is made but that I cannot access any of the tables. I have tried using other connection methods and get the same results. If I change the above to constr = "DSN=MYDSNCONNECTION;DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME Where MYDSNCONNECTION is the DSN connection set up in the data sources, the code works and the table is appended.
View Replies !
ODBC Connection Keeps Dropping Off...
I have a local user on our network running MS Access 2003 (on Win XP Home), which needs to connect to a Back-End MySQL DB on our Cobalt Qube 3 Server. I installed the correct software to run the Access on their Win XP OS, and installed the ODBC MySQL Driver 3.51. When I test the connection in the ODBC panel, CONNECTED ! Then I open MS Access, and great, the app works. If I then close MS Access and re-open, as soon as I hit a button which needs data from MySQL then I get an error stating that this IP cannot connect to the MySQL DB using Password (Yes). I have tried taking the password out of the DSN, and user account for MySQL, but this makes no difference. After the second time trying to open MS Access, it brings up the ODBC Admin panel, and I have to delete the password and try to connect, 'connection failed', then enter the password 'connected!'. If I then open Access it runs, if I then exit & re-start the app 'Cannot connect using IP........., using Password...) I have double checked all the settings in the DSN, and their user account for the MySQL DB. Surely, the PC should be able to connect either all the time, or not at all, not just once, and then lose the connection
View Replies !
ODBC Connection Error
I am trying to configure an ODBC connection to a MySQL database, 5.0.12 Beta-nt. We testing the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query If I try to connect via cmd prompt the following message is displayed; ERROR 2013 (HY000) : Lost connection to MySQL server during query The strange thing is if I disable Norton Internet Security all works fine. The Windows Xp firewall is turned off and Norton has been configured to allow MySQL.
View Replies !
Jdbc / Odbc Connection
I am running Suse 10.1 and i have MySQL working fine but Im having problems with connecting my Java Application with my Database. I got the recent J Connector drivers but i keep getting the exception about it not being able to find my device driver. The only other thing I was un-able to figre is where is "%Java_home% /jre/lib" is that only for windows?
View Replies !
ODBC Connection Failure
Does anyone know how to solve this connection problem ? [MySQL][ODBC 3.51 Driver]Host 'adsl-76-205-58-150.dsl.pltn13.sbcglobal.net' is not allowed to connect to this MySQL server This connection works fine when I am in a static IP environment but does not when I am using DSL from home.
View Replies !
ODBC Connection String
I am writing the C++ code that will connect to the mySQL database. It will use ODBC. I have a mySQL + unixODBC + myodbc installed on my Linux box. I created a DSN for my user and can successfully connect to the DB 'localhost' from isql. isql test root I put the password in the odbc.ini file. However, when writing the C++ code, I need a connection string. So far I tried: DSN=test;UID=root;PWD=<password> DSN=test;UID=root;Password=<password> However, the program does not connect to the server.
View Replies !
ODBC Connection Timeout
Hope someone can help me with ODBC connection error I'm having. Have installed mysql 5.0.12 beta-nt and ODBC 3.51.12 on XpPro sp2 machine. I have configured the driver and all works well untill I activate Norton Internet Security. If this is enabled and I use the ODBC configuration tool to test the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query Windows firewall is turned off and Norton has been configured to allow MySQL. Is the Norton thing a red herring .
View Replies !
Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server. Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).
View Replies !
ODBC / MySQL Connection Issue
I'm trying to allow someone from a specific IP to connect to a mySQL db w/OBDC. I've run several GRANT queries on the mysql db i.e. GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemo.* to 'aname'@'24.55.41.125' identified by 'pwd232123'; GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemostore.* to 'aname'@'santamonica-cuda4-24-55-40-1.vnnyca.adelphia.net' identified by 'pwd232123'; but when I try to connect I get "Request returned with SQL_ERROR." Any ideas? Does it sound like a GRANT issue?
View Replies !
MySQL ODBC Connection Problem
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
View Replies !
ODBC Connection To External MySQL DB
I am running VB6 (old I know) and trying to connect to an external database (on my server). I have the "MySQL Connector/ODBC 3.51" installed (which I think I need). However when I run my VB6 application I am getting the following error: Run-time error ?' HY000 [MYSQL][ODBC 3.51 driver] could not find driver {MYSql ODBC 3.51} in system information. I was able to do this on my older server, from my old home PC ages ago but I can't remember what I did to get it work.
View Replies !
Odbc Connection :: Get Data From Excel Sheet
I have excel running on a macintosh OS X box. My webserver is on a linux box with mysql and php on it. Is there a way i can create an odbc connection so that I can get mysql data to my excel spreadsheet from excel? OR Can I use odbc to connect to a mysql database on a remote machine? I want to write a macro in excel which should retrieve data from mysql. I am basically in a situation where I had created a web interface from an excel worksheet, and now I can add new records via the web. But now I have to get the data back to excel(in fact I have to update the very same excel worksheet). Sounds redundant, but I have to do this.
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
MySQL Tables Performance
I have a table where misc data are stored. Right now this table has about 30 columns, but for sure it will be more in the near future. So I wonder how the big number (50-100) of table's columns affect for MySQL DB performance. Maybe it's better to create more tables rather than more table's columns ??
View Replies !
Performance Affected By Tables
I'm develloping a game which will have to store information about objects located in each square of a large grid. Since there can be many, or none, or a combination of different objects in any given square at a time, I figure I should create a table for each square on the grid containing the names of the objects in it. This may lead up to 1000-5000+ tables though, many of which could/will be empty, and I was wondering if that is the best approach I can take?
View Replies !
Tables Structure - Performance
I need to design a table structure for a new application. We are using MyIsam tables. I am not sure which approach is better: a simple structure with 2 or three hudge tables or a more complicated structure with 6, smaller, tables. I see the benefit of the first way that because I will be able to get more info with less queries. I also see the benefit of the second way because it will better represent the data and also maybe because the tables are smaller it will be faster then quering a hudge table.
View Replies !
Performance Of A Database With A Lot Of Tables
I am working on hosting solution for a popular open source script, where users can sign up and get an own forum. We use InnoDB, and each user has an own set of tables (around 30); there are currently around 500 users registered. Despite the large count of tables, database is small, around 50 MB. Server is dual Xeon with 4GB of RAM and MySQL uses all memory, available on the server, so there's even nothing left for Apache. As the user base is growing, what steps would you suggest me to do, in order to keep good database performance and make it more efficient on RAM usage? The former is more important.
View Replies !
Navicat For SQL Runtime
Does anyone know if there is a runtime for Navicat 7? The organization I work for is interested in buying this product but we only need about 3 or 4 people to create reports, however, we want everyone to be able to view the reports. So, I am trying to find (with little success) if we will have to purchase a liscence for every computer even if the users are only viewing data, or if we only have to purchase a liscence for the people who develop reports, and the rest can use some sort of runtime in order to access the reports.
View Replies !
Swithing To Mac, Navicat? Or?
I'm switching to a Mac, and I'm looking for MySQL Database Tools. On Windows I used Navicat and loved it, and I was planning on purchasing the Mac version. But are there any other database tools for the Mac I should consider as well?
View Replies !
Large Unused Tables Vs Performance
I've been working on a website with a rather large a database. One of the about 100 tables in there was about 1/4 of the total database size. The table had no use anymore at the time I worked the website, so it was just sitting there, doing absolutely nothing. Obviously to spare diskspace we deleted the table. But the question I have now, can unused large tables affect the perfomance of Mysql? I've searched a bit around, but honestly I couldn't find a clear answer about it right away (maybe I haven't searched enough either :) )
View Replies !
Slow Joining Of Two Tables
I am having trouble combing data from two tables. The tables have exactly the same layout, but have different : mysql> describe MONITORINGUNIT1_DATA; +-------------+-------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------------------+-------+ | dt | datetime | | | 0000-00-00 00:00:00 | | | wg | float(20,3) | YES | | NULL | | | dflag_wg | tinyint(4) | YES | | NULL | | +-------------+-------------+------+-----+---------------------+-------+ mysql> select count(dt) from MONITORINGUNIT1_DATA; +-----------+ | count(dt) | +-----------+ | 24144 | +-----------+ 1 row in set (0.00 sec) mysql> select count(dt) from MONITORINGUNIT2_DATA; +-----------+ | count(dt) | +-----------+ | 1464 | +-----------+ 1 row in set (0.00 sec) Very briefly, [dt] contains an hourly date/time stamp representing when the reading [wg] was taken. [dflag_wg] contains a integer that describes the data (over threshold, under threshold, etc). The DB is populated automatically by a Python script that executes once per hour. If I want to get the overlapping data (with the same date/time stamp) I use this query: Code:
View Replies !
Slow Insert To Tables
I am inserting 70,000 Records to one mysql table, this table is a simple table with no indexes or primary keys (it consists of 3 columns), add those records takes me like 35 mins on a P4 Machine with 2.5GB of RAM. It is very slow comparing to Access or SQL Server.
View Replies !
Enum Setting Using NaviCat
This is what I am doing something wrong with my mySQL NaviCat. My php says that I have a error " Unknown column 'type' in field list" Is my Setting for MySQL correct???? ....
View Replies !
Link ODBC Tables
I would like to link MySql to a Informix Unidata ODBC datasource the way that Access lets you link tables with get external data. Is this possible without doing a full import? A full import is out of the question since the data is always changing on the Unidata side. Right now we use Access to run queries off of the Unidata source, but it is extremely choppy and slow since there are 10s of thousands entries.
View Replies !
Slow Join On Large Tables
I have two tables: D (500,000 recs), and DL (2,500,000 recs) D has a PK and an index on HLQ. DL has a PK and an index on ID. The following SQL: SELECT HLQ as "HLQ", count(*) FROM D, DL WHERE D.DLID=DL.ID GROUP BY HLQ produces the following explain: tabletypepossible_keyskeykey_lenrefrowsExtra DALL500000Using where; Using temporary; Using filesort DLeq_refIDID4D.DLID1Using index The query takes ~ 3:30 on a Athlon xp2200; 1GB RAM; default bufer settings. Adding the following buffer settings only slightly decrerased the time (~3:00). key_buffer=512M table_cache=256 sort_buffer=16M read_buffer_size=16M It appeasrs that the 'Using filesort' on table D is due to the Group By clause and is the problem. I have an index on HLQ. Is there any way to get MySQL to use it?
View Replies !
Large Tables, Very Slow Deletes.
I've been using MySQL for a while now and are starting to run into limitations. Either my own, or something else. I have this really large table, it stores images, it has a mediumblob field, an unsigned id integer field and a timestamp field. This table contains up to a few million rows and is constantly filled real time. It grows up to sizes between 50 and 100 gb and in the future probably even larger. This data is not supposed to be stored for all time, therefor when a certain treshhold is reached, the oldest 5000 rows are deleted to make room for newer rows. This is where my problem kicks in. Whenever I try to delete those rows, it can take for ever to complete. 500 rows I can delete without problem, 2500 becomes slow, 5000 rows takes several seconds and 10.000 rows or more makes it looks like things are frozen. Now the temporary solution I have is to delete 500 rows at time, but this means I must do that every 10 seconds just to maintain status quo. I would much rather check every 5 minutes or so, and if needed delete 15.000 rows in one go. I use MyISAM tables and tried setting the key size to 128M, no luck. I run this on a dual Opteron system with a GB of memory and WinXP-SP2 Proffesional.
View Replies !
Federated Tables Slow? (like 4.5 Hrs For A Query)
I've got a problem with federated tables. I'm using MySQL 5.1 (with InnoDB as the default table type) on a Win2K server, on which I've got four federated tables pointing at four MyISAM tables on a MySQL 4.1.11 server. Of the four tables, three of them run just fine, and I can retrieve data quickly with no problems. The fourth is a sheer pig. While they have different columns, all four tables are roughly as complex as each other, all having the same features and developed by the same team. The most obvious difference, and what I suspect might be the problem, is that the first three tables have between 150 and 1,000 records, the fourth table has closer to 15,000. Still, there isn't that much lag when I'm pulling from the smaller tables, and the lag is really serious when I'm pulling from the larger one; I ran three queries last night to test, and I could pull data from the smaller tables in about 5 minutes, but the larger table took 4.5 hours- possibly because it was joined with two other tables, but the joins on the smaller tables didn't cause this kind of problem. The second obvious difference is the fact that I'm pulling from a MyISAM table into a federated table... from which I would like to store into an InnoDB table, but it ends up timing out quite a bit. Connecting to the database I've federated to isn't a problem. It responds to a PHP frontend lightning-fast. It's just my federated tables that suck so bad. I wouldn't even use federated tables, but I need to pull from the MyISAM database for storing historical records of inventory. What am I doing wrong, and what can I do to speed things up?
View Replies !
Remote ODBC Tables Via MySQL
I've been using MySQL as a db engine behind a PHP application, and it has worked very well so far. Now I need to access some data held in a remote Oracle database and the only access I'm likely to get is via ODBC. I know the federated engine only works with MySQL, but is there a way of viewing these tables through MySQL? It would be much simpler (and more portable in the long run) to maintain an illusion for the app that it is looking at only one database. If there's no way to do this, will I need to set up a script that dumps data into the local database?
View Replies !
|
TRACKER
