hi,
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
How to optimize the attac
hi,
i have attached my geometric query which is very slow. how to optimize this
query
regards
shann
___
Hot new product - Spider Networks introduces stunning online ePortfolio
solution for students and teachers
http://www.spider-n
yes.
on linux it is possible to convert shp files you have to use libmygis
avaliable at http://jcole.us/software/libmygis/
shann
___
Halloween Humour: Why did Dracula divorce his wife after 800 years?
postmaster.co.uk
http://www.
hi,
thnaks for the speedy reply. I already have both the DBs in my server. is there
any way/method that the DB2 which needs transaction support can be converted
from myisam to innodb format without any hitch
regards
shann
___
Which f
hi,
I need to have 2 DB in our development/production environment which require
both InnoDB and MyISAM engines. This is bacasue, DB1 contains spatial/geom data
which has to be on MyISAM engine and DB2 which needs transactional support has
to be InnoDB.
Now how to achieve this co-existance of
hi
as per the online manual, i have configured mysql and able to run the server as
mysqld_safe. but if i want to run mysqld_multi with the following configuration
it doesnt work... the config file is like
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/
hi,
i have created / imported a table to mysql thru mysqlgisimport libraries and it
has created a table with the following field / table structure
Field name Type Allow nulls? Key Default value Extras
id int(10) unsigned No Primary NULL auto_increment
NAME varchar(100) No N
