Glom 'Find' function

View: New views
5 Messages — Rating Filter:   Alert me  

Glom 'Find' function

by Jan Smith-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I downloaded and made a small Glom database for Computerbank using the following versions of software.

Glom 1.8.7                   
Postgres 8.3                    
Ubuntu 8.10
Hardware: Pentium 2.4 Ghz, 1 Gig Ram

I am very happy with the look and feel of the of the Glom database but it takes 7 seconds to do a search.  By this I mean it takes 7 or more seconds when the 'Find' button is pressed until the desired record is shown. My database so far only has 60 records. Is the 'Find' function usually this slow?

Any suggestions greatly appreciated.

Jan Smith
Volunteer
Computerbank Victoria
http://computerbank.org.au/


_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

Re: Glom 'Find' function

by Murray Cumming :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wed, 2009-05-27 at 15:29 +1000, Jan Smith wrote:

> Hi,
>
> I downloaded and made a small Glom database for Computerbank using the
> following versions of software.
>
> Glom 1.8.7                    
> Postgres 8.3                    
> Ubuntu 8.10
> Hardware: Pentium 2.4 Ghz, 1 Gig Ram
>
> I am very happy with the look and feel of the of the Glom database but
> it takes 7 seconds to do a search.  By this I mean it takes 7 or more
> seconds when the 'Find' button is pressed until the desired record is
> shown. My database so far only has 60 records. Is the 'Find' function
> usually this slow?

Is that when using the Quick Find entry, or when doing a precise find in
a particular field? Are you using a local PostgreSQL instance
(self-hosting, for instance), or one on a separate computer?

I would expect the Quick Find to be slightly slower (maybe it should be
called "simple" rather than "quick") because it searches all fields, by
making a big SQL statement, but I wouldn't expect it to be that slow.

--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

Re: Glom 'Find' function

by "Arq. Maximiliano" Meilán :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Have the same version of Glom and Ubuntu, Athlon+2.4, and 2 Gig Ram
Have 40 records, and Find (Ctrl F) under list tab takes 7 or 8 seconds.
When search from a remote computer (Pentium II), takes 20 seconds
Maximiliano



El mié, 27-05-2009 a las 16:13 +0200, Murray Cumming escribió:

> On Wed, 2009-05-27 at 15:29 +1000, Jan Smith wrote:
> > Hi,
> >
> > I downloaded and made a small Glom database for Computerbank using the
> > following versions of software.
> >
> > Glom 1.8.7                    
> > Postgres 8.3                    
> > Ubuntu 8.10
> > Hardware: Pentium 2.4 Ghz, 1 Gig Ram
> >
> > I am very happy with the look and feel of the of the Glom database but
> > it takes 7 seconds to do a search.  By this I mean it takes 7 or more
> > seconds when the 'Find' button is pressed until the desired record is
> > shown. My database so far only has 60 records. Is the 'Find' function
> > usually this slow?
>
> Is that when using the Quick Find entry, or when doing a precise find in
> a particular field? Are you using a local PostgreSQL instance
> (self-hosting, for instance), or one on a separate computer?
>
> I would expect the Quick Find to be slightly slower (maybe it should be
> called "simple" rather than "quick") because it searches all fields, by
> making a big SQL statement, but I wouldn't expect it to be that slow.
>


_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

Re: Glom 'Find' function

by Murray Cumming :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Fri, 2009-05-29 at 11:26 -0300, Arq. Maximiliano Meilán wrote:
> Have the same version of Glom and Ubuntu, Athlon+2.4, and 2 Gig Ram
> Have 40 records, and Find (Ctrl F) under list tab takes 7 or 8 seconds.
> When search from a remote computer (Pentium II), takes 20 seconds
> Maximiliano

Again, is this a quick find or a specific find in a certain field?

If it's a quick find, how many fields are in that table?

> El mié, 27-05-2009 a las 16:13 +0200, Murray Cumming escribió:
> > On Wed, 2009-05-27 at 15:29 +1000, Jan Smith wrote:
> > > Hi,
> > >
> > > I downloaded and made a small Glom database for Computerbank using the
> > > following versions of software.
> > >
> > > Glom 1.8.7                    
> > > Postgres 8.3                    
> > > Ubuntu 8.10
> > > Hardware: Pentium 2.4 Ghz, 1 Gig Ram
> > >
> > > I am very happy with the look and feel of the of the Glom database but
> > > it takes 7 seconds to do a search.  By this I mean it takes 7 or more
> > > seconds when the 'Find' button is pressed until the desired record is
> > > shown. My database so far only has 60 records. Is the 'Find' function
> > > usually this slow?
> >
> > Is that when using the Quick Find entry, or when doing a precise find in
> > a particular field? Are you using a local PostgreSQL instance
> > (self-hosting, for instance), or one on a separate computer?
> >
> > I would expect the Quick Find to be slightly slower (maybe it should be
> > called "simple" rather than "quick") because it searches all fields, by
> > making a big SQL statement, but I wouldn't expect it to be that slow.
> >
>
>
--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

Re: Glom 'Find' function

by "Arq. Maximiliano" Meilán :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

It's a quick find. For example search the name of a customer in all the
table.
Have 60 fields in the table and 40 records.
Maximiliano



El vie, 29-05-2009 a las 17:29 +0200, Murray Cumming escribió:

> On Fri, 2009-05-29 at 11:26 -0300, Arq. Maximiliano Meilán wrote:
> > Have the same version of Glom and Ubuntu, Athlon+2.4, and 2 Gig Ram
> > Have 40 records, and Find (Ctrl F) under list tab takes 7 or 8 seconds.
> > When search from a remote computer (Pentium II), takes 20 seconds
> > Maximiliano
>
> Again, is this a quick find or a specific find in a certain field?
>
> If it's a quick find, how many fields are in that table?
>
> > El mié, 27-05-2009 a las 16:13 +0200, Murray Cumming escribió:
> > > On Wed, 2009-05-27 at 15:29 +1000, Jan Smith wrote:
> > > > Hi,
> > > >
> > > > I downloaded and made a small Glom database for Computerbank using the
> > > > following versions of software.
> > > >
> > > > Glom 1.8.7                    
> > > > Postgres 8.3                    
> > > > Ubuntu 8.10
> > > > Hardware: Pentium 2.4 Ghz, 1 Gig Ram
> > > >
> > > > I am very happy with the look and feel of the of the Glom database but
> > > > it takes 7 seconds to do a search.  By this I mean it takes 7 or more
> > > > seconds when the 'Find' button is pressed until the desired record is
> > > > shown. My database so far only has 60 records. Is the 'Find' function
> > > > usually this slow?
> > >
> > > Is that when using the Quick Find entry, or when doing a precise find in
> > > a particular field? Are you using a local PostgreSQL instance
> > > (self-hosting, for instance), or one on a separate computer?
> > >
> > > I would expect the Quick Find to be slightly slower (maybe it should be
> > > called "simple" rather than "quick") because it searches all fields, by
> > > making a big SQL statement, but I wouldn't expect it to be that slow.
> > >
> >
> >
--
                  ____________________________________
                             Estudio MEILÁN
                     (arquitectura y construcción)
                  Avda. Artigas y Zabala - Piriápolis
                  Tel.(043) 27431 - www.meilan.com.uy
                  ____________________________________

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list