SCO issue

h SCO partnership, good luck, but (being long time MySQL user and alpha bug reporter) I would switch to Embedded PostgreSQL myself and encourage other people to do the same. I use _tons_ of GPL software so should I help funding of my own annoyance (albeit poorly supported with facts) ?

Re: MinGW and MySQL

g any funcion of MySQL API causing crash. I would highly recommend adding .a library for mingw to official win32 distribution of MySQL (if anybody from MySQL AB can hear me). I submitted bug already, it is "verified" but so far nothing happens. Mirza -- MySQL General Mailing List Fo

Re: Spatial extensions and GIS

In both cases you will have to write your own code. MySQL, so far, only can store Spatial data and do very simple (still, r-tree optimized) GIS queries (like: all objects inside rect). mirza Terry Pothecary wrote: Hi. This may be a daft question, so forgive me: I am just starting out with the

Re: Speeding up Inserts

Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to

Re: many updates really slow

if it is part of app. use soap to communicate with server and adopt your application. Send all your commands as one string parameter to server, and execute it all there. Such modification to is quite simple to write using gSoap library (if your application is C++ based) or Axis (Java). mirza

Cygwin

Does anyone knows where to find headers and libraries for mysql development on Cygwin platform? thanks. Mirza Hadzic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.2.?

Hi, Is there any info on when 4.1.2 is to be released? Mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Version 4.1.2. when?

Is there any info on when 4.1.2. is scheduled for relase? I am stucked in 4.1.1. with fulltext problem (bug #2490). Thanks for info, mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB loading: add keys before or after

In theory it is fastest to add indexes first, then disable it (ALTER TABLE x DISABLE KEYS), then add data and, on the end, re-enable keys (ALTER TABLE x DISABLE KEYS). mirza Keith Thompson wrote: Hello all, I need to load a new InnoDB table with about 80 million rows. With MyISAM I have often

Re: Searching for matching zipcode in a list of (ranges of) zipcodes

Original Message Subject: Re: Searching for matching zipcode in a list of (ranges of) zipcodes Date: Wed, 14 Jan 2004 14:14:19 +0100 From: Mirza <[EMAIL PROTECTED]> To: Tom Hesp <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Hi, If you rewrite ranges

Embedded MySQL example with g++?

Is there any example of makefile for g++ that links libmysqld? So far I can link libmysqld only with gcc-based programs, but g++ gives lots of unresolved symbols (like __pure_virtual etc.). thanks, Mirza Hadzic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Embedded 4.1.1 - Linux

Hi, Is there any site with list of libs I need to link with libmysqld (linux)? I am currently using libmysqlclient and thisone needs libpthreads and libz to work fine. If I replace libmysqlclient with libmysqld, there is lot of symbols linker cannot find. Thanks, Mirza -- MySQL General

4.1.1. -> WITH QUERY EXPANSION

Hi, In 4.1.1. new features there is: * Added `MATCH ... AGAINST( ... WITH QUERY EXPANSION)' and the `ft_query_expansion_limit' server variable. What is WITH QUERY EXPANSION? I found no details in manual. mirza -- MySQL General Mailing List For list archives: http://lists.mysql

can't find FULLTEXT index

Hi, I have error 1191 "can't find fulltext index matching the column list", but I am certain that all columns in the list are present in my Fulltext index. Does anybody else had this problem? I am using 4.1.0. thanks, Mirza -- MySQL General Mailing List For list

Index before or after inserts?

I need to insert hundreds of milions of records to a table and make several indicies on it. Now, is it faster to make tables with indicies and then fill tables or fill tables first, then make indicies? Any experiancies? regards, mirza -- MySQL General Mailing List For list archives: http

4.1 crashes on geo select

inside streets table. I have tested table and test shows that everything is OK. Mirza Hadzic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: INSERT INTO () SELECT...

Hi Eric, thats oracle function INSERT INTO ... SELECT. it doesn't work in mysql. Mirza [EMAIL PROTECTED] __ 21.11.2002 22:13 > Hi, > This should work, I think, but doesn't > INSERT INTO holds (ord_num) > SELE

mysql: multiple SELECTs with INSERT or UPDATE??

2nd question, is it possible to use UPDATE and (mulstiple) SELECTs together i.e.: UPDATE mytable SET xxx = (SELECT xxx from mytable2 WHERE config="yyy") ... thanx Mirza - Before posting, ple

mysql@lists.mysql.com

ysqlclient.so.6: open failed: No such file or directory Killed >Fix: I don't know how to fix this problem. >Submitter-Id: >Originator:Azrinsyah MIRZA-ASFIAN >Organization: >MySQL support: [none | licence | email support | extended e