MySql Native Connector 30x slower dan ODBC connector

[drewjensen]

Correction

> - the search dialog is not  modal - but you can apply the search and
> see the record found without clearing the dialog from the screen -
> can't work with the calling form however until it is (is that really
> necessary?)
>

- the search dialog is modal - but you can apply the search and see the
record found without clearing the dialog from the screen - can't work
with the calling form however until it is (is that really necessary?)



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Drew Jensen wrote:

>
> Correction
>
>> - the search dialog is not  modal - but you can apply the search and
>> see the record found without clearing the dialog from the screen -
>> can't work with the calling form however until it is (is that really
>> necessary?)
>>
>
> - the search dialog is modal - but you can apply the search and see
> the record found without clearing the dialog from the screen - can't
> work with the calling form however until it is (is that really
> necessary?)
>

before I get carried away here - isn't this in the Base Getting Started
guide??

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Drew Jensen wrote:

> Drew Jensen wrote:
>>
>> Correction
>>
>>> - the search dialog is not  modal - but you can apply the search and
>>> see the record found without clearing the dialog from the screen -
>>> can't work with the calling form however until it is (is that really
>>> necessary?)
>>>
>>
>> - the search dialog is modal - but you can apply the search and see
>> the record found without clearing the dialog from the screen - can't
>> work with the calling form however until it is (is that really
>> necessary?)
>>
>
> before I get carried away here - isn't this in the Base Getting
> Started guide??
>

LOL - is this turning email list server into Twitter..and I thought
Twitter invented something all new..

Anyway - there is a problem - go to the Getting started Guide at the
wiki - drill down (select from the menu) to Base - do a search for
'Filter'...

No - I don't want to know how to support SVG in C++ import filters...or
is that Java...well, you get the idea....

[Actually - I know there is a serach box on the Support page that will
limit the search to the user docs...let's try..]
go to OO.o main page -> Support -> Documentation
Fill in the custom search box "OOo Manuals on the Wiki " and enter the
search
Base Filter

--we get --
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Creating_a_bibliography

No wonder I missed it in the Base section of the Getting Started Guide.

-- Ok -- so let's get carried away this afternoon.

@Dan Lewis - just in case you read this email...I saw your email at
Authors that you are still working on the Base User Guide...if you can
use the following screen shots, etc...please do
@Dimirti - Howdy..<I know you read this list>.. Hey, this is a great
idea for one of those Linux magazine articles....hint hint...(you got
that memo about you being the groups adjunct journalist...right *smile*)

Off to play with Impress...

Drew

p.s. "is this turning email list server into Twitter." - guess not, too
many lines for twitter...*^_^*


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Hallo Drew

"before I get carried away here - isn't this in the Base Getting Started
guide?? "
a quick googling says NO
The important question is way is Filtering QUICK and Searching SLOW !

greetz
Fernand

> Drew Jensen wrote:
>>
>> Correction
>>
>>> - the search dialog is not  modal - but you can apply the search and
>>> see the record found without clearing the dialog from the screen -
>>> can't work with the calling form however until it is (is that really
>>> necessary?)
>>>
>>
>> - the search dialog is modal - but you can apply the search and see
>> the record found without clearing the dialog from the screen - can't
>> work with the calling form however until it is (is that really
>> necessary?)
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Fernand Vanrie wrote:
> Hallo Drew
>
> "before I get carried away here - isn't this in the Base Getting
> Started guide?? "
> a quick googling says NO
> The important question is way is Filtering QUICK and Searching SLOW !
>

Well - I can help with showing you how to make searching faster in your
databases - but as for making the actual code run faster..that is not in
my pay grade.

I can tell you that it has gotten faster from version 2 to version 3 and
gets faster again in 3.2....is it faster enough now..depends I suppose.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Drew Jensen wrote:

> Fernand Vanrie wrote:
>> Hallo Drew
>>
>> "before I get carried away here - isn't this in the Base Getting
>> Started guide?? "
>> a quick googling says NO
>> The important question is way is Filtering QUICK and Searching SLOW !
>>
>
> Well - I can help with showing you how to make searching faster in
> your databases - but as for making the actual code run faster..that is
> not in my pay grade.
>
> I can tell you that it has gotten faster from version 2 to version 3
> and gets faster again in 3.2....is it faster enough now..depends I
> suppose.
>

@Fernand - jsut to be sure...I will supply a database for our use -
makes it easier for a narrative.
Just finished (well more or less) a file using embedded HSQLdb for this
...but a MySQL example is appropriate here?
(anyone have opinion here as to specifics)
- MySQL 5.1
- Engine InnoDB (MyISAM is what Base uses by default)
- I'll create a separate 'schema' and create a dump file...good enough?
- Also supply the odb file?

Let me know if you have opinion on that OK...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

> @Fernand - jsut to be sure...I will supply a database for our use -
> makes it easier for a narrative.
> Just finished (well more or less) a file using embedded HSQLdb for this
> ...but a MySQL example is appropriate here?
> (anyone have opinion here as to specifics)
> - MySQL 5.1
> - Engine InnoDB (MyISAM is what Base uses by default)
> - I'll create a separate 'schema' and create a dump file...good enough?
> - Also supply the odb file?
>
> Let me know if you have opinion on that OK...
>

I mean - unless you have a schema that you would rather use for an
example here?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

> -- Ok -- so let's get carried away this afternoon.
>
> @Dan Lewis - just in case you read this email...I saw your email at
> Authors that you are still working on the Base User Guide...if you can
> use the following screen shots, etc...please do
> @Dimirti - Howdy..<I know you read this list>.. Hey, this is a great
> idea for one of those Linux magazine articles....hint hint...(you got
> that memo about you being the groups adjunct journalist...right *smile*)
>
> Off to play with Impress...
>

But before I did that - took a look at this wiki page (a long dormant
outline for a Base manual)
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning

Now - without actually going to the mail list to search - IIRC Dan
posted a message at OOAuthors that he had 'more or less' wrapped up
Chapter 1
- assuming he was following that outline
-- 1.6 How to find your information (Searches and Filters) (general,
with ref to Chapter 4 for details)
So maybe some basic screen shots are done already

-- then looking at the entry for Chapter 4

> Chapter 4: Data (information) output
>
> 4.1 Query Wizard
>
> 4.2 Report Wizard
>
> 4.2.1 Tables and Queries and SQL
>
> 4.2.2 Chose a layout
>
> 4.2.3 Can I make this little change?
>
> 4.2 Example (flat d/b)
>
> 4.3 Example (relational d/b)
>

Not sure I see where the filter/search piece was laid out...hmm...




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> Frank,  are you telling that after opening a table  and after we scroll
> to the last record, (I suppose we have the content off the table now in
> memory) the search go's back to the Server to find a result ?? and the
> search is not using the resultset already present in the memory off the
> local machine ?

We do not cache the complete result set. There is a client-side cache,
which control how many records are *completely* held in memory.  This is
defaulted to 50 rows, or "2*visible rows" if there's a grid control
involved. Other than that, we only cache values which uniquely identify
a row (the PK, or a unique index field, or a bookmark).

> BTW: filtering is done where ?

On the server: a new SQL statement is created, including the filter, and
all data is completely re-fetched.

Even if Base would cache the complete data, filtering would still be
faster (assuming a reasonable connection to the server), since the
server usually knows best how to organize its data for quick
access/filter/search (e.g. if you defined an index for a column, and
filter for those col's values).

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Drew Jensen wrote:

>
>> @Fernand - jsut to be sure...I will supply a database for our use -
>> makes it easier for a narrative.
>> Just finished (well more or less) a file using embedded HSQLdb for this
>> ...but a MySQL example is appropriate here?
>> (anyone have opinion here as to specifics)
>> - MySQL 5.1
>> - Engine InnoDB (MyISAM is what Base uses by default)
>> - I'll create a separate 'schema' and create a dump file...good enough?
>> - Also supply the odb file?
>>
>> Let me know if you have opinion on that OK...
>>
> I mean - unless you have a schema that you would rather use for an
> example here?

I already opened a MySql server for Frank (to test the connections) with
a real live 28.000 records table in it. If you wand to use this database
give me a private email adres and i send you the acces details

Fernand
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...