Zeoslib Portal

Using PivotCube on dataset with 25.000 records and 27 solumns- speed is OK. Or maybe I should test another component to compare.. Time to process is about 10 -20 seconds (depends a litle probably because usage of varcahr fields).

How many records and coluimns do you have in the dataset.

Ok, thanks!

I'll make the routines - BTW: If anyone needs them, just drop me a PM or mail..

I will show you what I mean: I have two databases of the same application, but different versions. This means that some tables are missing, some fields are missing, some fields are different (type, size) or some indexes are missing/different. I would like to see the differences between the two datab...

Hello!

Does anyone know how to compare two database (on the same server) structures? If there's any Delphi code it would be great..

Yes.

But you have to set up the server correctly (utf8 tables,.. etc.).

Seems OK to me, too. I'll test it ASAP. For the embedded MySQL can remain as a separate driver type (mysql, mysqld), so the automatic version detection would work separately. @tohenk: Great idea! @mdaems: The idea is great, but it must be applied carefully. Is it included in any SVN version or I nee...

What is this?

what do the blobs contain? Is there any average size estimation of blobs? Also - watch the memory usage during table opening. Is there a possibility that the PC begins to swap (hint: massive disk LED blinking.. :) ) beacuse no more RAM available? If yes, then the tables are too big. And of course - ...

Don't know much about proxies, but do you have any useful data? I don't think Zeos have any functions/properties for proxy connecting...

Check the DLLs, could be a version problem?

Well, I use stored procedures very differently from you, so maybe it could work my way: I use just querys, like this: For Functions: Query1.SQL.Text := 'Select MyFunction(Param1,Param2)'; Query1.Open; MyResultVariable := Query1.Fields[0].AsInteger; // (AsString,... etc.) For Procedures: Query1.SQL.T...

More ways to do that: a) via SQL: Select * from Table limit 0,100 Select * from limit 100,100 Select * from limit 200,100 ... (more on http://dev.mysql.com/doc/refman/5.1/en/select.html ) b) via cached datasets. Make the property Query.CachedUpdates := true and then Query.Delete without affecting th...

Could be that you selected an embedded version of MySQL by mistake?

Procedures do not return values if I'm not wrong - functions do that. To return a value from the function follow this example (syntax is aproximative): DELIMITER $$ DROP FUNCTION IF EXISTS `test`.`USR_MULTIPLY` $$ CREATE FUNCTION `USR_MULTIPLY`(X Integer, Y Integer) RETURNS Integer DETERMINISTIC COM...

It can be done just by ZQuery too:

Query1.sql.text := 'Call NewDocument("xx",12)';
Query1.Execute;