Problems with my search

------=_NextPart_000_0047_01C06033.A8C38B80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello, I am developmenting a virtual shop and I have 2000 products. (Is
it possible work with a lot of products ?).=20
=20
I want to search my products for category, area and subarea,
depending of a table than have keys words. I must make <mvwhile> very
complicates, and the searching are very slowly.
=20
Is there some rutine for search more fast ?
=20
Is really miva for great search ?
=20
Thank you for your valuable time,
Carlos Jordan.
=20
PD: I am sorry for my English.


------=_NextPart_000_0047_01C06033.A8C38B80--

Problems with my search



Carlos

Is it not possible to use MvFIND?
Especially if you wish to retrieve a few from very many records
this should be super fast. If you have not used MvFIND before
then read the documentation and create the indexes required.

I understand you have 2000 products - is this also how many records?
If so then even doing a MvFILTER should not be a problem. Even a free
text search within a memo field of up to 4,000-5,000 records
should be possible in an acceptable time.

If MvFIND is not the answer for you then why not post more details of
your search coding and the experts can advise (I'm far from expert)

Andy Miller
Futurevantage : The place to start for bank and insurer information
http://futurevantage.com

> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On
> Behalf Of Carlos Jord=E1n
> Sent: 07 December 2000 09:54
> To: [email protected]
> Subject: [meu] Problems with my search
>
>
> Hello, I am developmenting a virtual shop and I have 2000
> products. (Is
> it possible work with a lot of products ?).
>
> I want to search my products for category, area and subarea,
> depending of a table than have keys words. I must make <mvwhile> very
> complicates, and the searching are very slowly.
>
> Is there some rutine for search more fast ?
>
> Is really miva for great search ?
>
> Thank you for your valuable time,
> Carlos Jordan.
>
> PD: I am sorry for my English.
>
>

Problems with my search



Thank for you answer. Andy Miller.

I put a filter in my database some complicate, and after I need to know =
how
register found it but I don't know to do this. I have to do

<mvwhile>
<mvassign name=3D"numreg" value=3D"{numreg + 1}">
<mvskip>
</mvwhile>

I need this for show my registros by pages.

Thank very much. Andy.




----- Original Message -----
From: "Andy Miller" <[email protected]>
To: "'Carlos Jord=E1n'" <[email protected]>; "Mivalist (E-mail)"
<[email protected]>
Sent: Thursday, December 07, 2000 10:20 AM
Subject: RE: [meu] Problems with my search


> Carlos
>
> Is it not possible to use MvFIND?
> Especially if you wish to retrieve a few from very many records
> this should be super fast. If you have not used MvFIND before
> then read the documentation and create the indexes required.
>
> I understand you have 2000 products - is this also how many records?
> If so then even doing a MvFILTER should not be a problem. Even a =
free
> text search within a memo field of up to 4,000-5,000 records
> should be possible in an acceptable time.
>
> If MvFIND is not the answer for you then why not post more details of
> your search coding and the experts can advise (I'm far from expert)
>
> Andy Miller
> Futurevantage : The place to start for bank and insurer information
> http://futurevantage.com
>
> > -----Original Message-----
> > From: [email protected] =
[mailto:[email protected]]On
> > Behalf Of Carlos Jord=E1n
> > Sent: 07 December 2000 09:54
> > To: [email protected]
> > Subject: [meu] Problems with my search
> >
> >
> > Hello, I am developmenting a virtual shop and I have 2000
> > products. (Is
> > it possible work with a lot of products ?).
> >
> > I want to search my products for category, area and subarea,
> > depending of a table than have keys words. I must make <mvwhile> =
very
> > complicates, and the searching are very slowly.
> >
> > Is there some rutine for search more fast ?
> >
> > Is really miva for great search ?
> >
> > Thank you for your valuable time,
> > Carlos Jordan.
> >
> > PD: I am sorry for my English.
> >
> >
>
>

Problems with my search



Sorry bout that last message, just read the To: line carefully <g>...


----- Original Message -----
From: "Carlos Jordán" <[email protected]>
To: <[email protected]>
Sent: Thursday, December 07, 2000 12:54 AM
Subject: [meu] Problems with my search


Hello, I am developmenting a virtual shop and I have 2000 products.
(Is
it possible work with a lot of products ?).

I want to search my products for category, area and subarea,
depending of a table than have keys words. I must make <mvwhile> very
complicates, and the searching are very slowly.

Is there some rutine for search more fast ?

Is really miva for great search ?

Thank you for your valuable time,
Carlos Jordan.

PD: I am sorry for my English.