Mysql benchmark

2002-04-24 Thread Lorenzo De Vito
There are tools for benchmark on win32 via ODBC ? I would like to test sql query in my VB6 application. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

AIX 4 and mysql

2002-06-13 Thread Lorenzo De Vito
I've installed binaries files of mysql on my AIX 4, I've also intalled zlib-1.0.4.0.bff, when I run mysqld daemon it return me an error: I convert from italian language... 0509-036 Impossible load ./mysqld 0509-027 Cannot find ember shr.o 0509-022 Impossible load libz.a[shr.o] can anyone to

Query too slow

2002-07-17 Thread Lorenzo De Vito
I've this query that is too slow, how can I optimize this sintax ? SELECT * FROM table_1 INNER JOIN table_2 ON ID_table_2=table_1_ID INNER JOIN table_3 ON ID_table_3=table_2_ID INNER JOIN table_4 ON ID_table_4=table_3_ID INNER JOIN table_5 ON ID_table_5 = table_4_ID INNER JOIN table_6 ON

MySql developer

2001-04-12 Thread Lorenzo De Vito
I would like to know what experience need for development in MySql project, I read the istructions on the site but it say to send my software, so I want ask: What languages are required ? What kind of experience ? - Before

Importing data from Outlook Express

2001-04-18 Thread Lorenzo De Vito
I'm looking for Outlook Express API's, I want to import data from a .dbx file (archive outlook) into a MySql table. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

C++ API

2001-04-25 Thread Lorenzo De Vito
I would like to know where I can find examples and documentations about C++ mysql API's, I want create a class for access to connection.

Replication

2005-09-12 Thread Lorenzo De Vito
I'm setting up a database replication between a master and a slave. Why I need to use command |LOAD DATA FROM MASTER ? Can The replication process synchronize data e table structure at startup without launching loading commands ? Once ||synchronized with master the slave need again to be

cluster or replication

2005-09-12 Thread Lorenzo De Vito
I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database have the same tables and same structure. Each insert or update in database will be executed for each server within this broadcast, what's the

Re: cluster or replication

2005-09-13 Thread Lorenzo De Vito
This isn't a constraint, this is a limit, the goal is to have a bi-directional replication but I've not found solutions to my problem using mysql. I've a control access system with 9 minitowers which controls people access via RFID, each minitower is provided with linux and mysql synchronized

Re: query

2005-09-14 Thread Lorenzo De Vito
a simple select like this (if you know the order of tables): SELECT (tableb.valuea + + tableb.valueb + + tablea.valuec) FROM `tableb`, `tablea` where (tableb.valuea + + tableb.valueb + + tablea.valuec) = XXX XX N. Kavithashree wrote: hello i hv one query as explained

Compiling problems

2001-07-18 Thread Lorenzo De Vito
I'm trying to compile a C file with this: BCC32 -IC:\mysql\include -LC:\mysql\lib\opt -IC:\Borland\BCC55\Include importDB.c but it return me an error: Unable to open file 'COX32.OBJ' What's the better way to compile with 'mysql.h' ?