Slow Speed

[Noman]

i am developing a system using VB 6 and Ms Access 2000.
overall the system is working fine but at few instances
the program get stuck for few minutes like 2 to 3 minutes
i.e it is very slow.
the accasions where it gets slow exists when number of
records exceeeds 10,000 records.

Main Ocasion where program gets slow

in a table there is a field number,lenofnum,sale1,sale2
if we insert 10 records in a table from number 0-to-9
and in sale1 and sale2 we insert value 10,000 and
lenofnum=1.
now we want some sort of convertion.
like for each of the ten numbers i want to convvert that
single number number into each possible combination of
its double number. like
number 0 would be conveterd into
00,01,02,03,04,05,06,07,08,09 and the lenofnumwillbecome
2 and sale1 and sale2 would be divided into 10 equal
segments.
similarly number 1,2.....9 will be break in the same
sequence. this was single to double convertion.
now double to tripple.
like 00 will be converted into 000,001,002...009 again in
ten sub divions
then tripplet to four.
major problem occurs from tripplet to four bcoz then
number of tripplets are 1000 and when the split into four
they become 10000 and it takes 1 min 30 secs.
i ve tried my level best to decrease the time below a
minute but not succeded.
i ve also tried sybalse sql anywhere 5.0 but that took
more than 1 1/2 mins.
so pleeeease suggest me someything
please email me the solution

[EricJ]

upgrading to VB.NET and SQL server would go a lot faster ;p

seriously a access db isn't strong enough to handle that kind of load (it
wil work but not performant) if you think the number of records will keep
increasing in this way upgrade before your system hangs competely.

my 2 cents

eric

"Noman" <ri**********@hotmail.com> wrote in message
news:04****************************@phx.gbl...

i am developing a system using VB 6 and Ms Access 2000.
overall the system is working fine but at few instances
the program get stuck for few minutes like 2 to 3 minutes
i.e it is very slow.
the accasions where it gets slow exists when number of
records exceeeds 10,000 records.

Main Ocasion where program gets slow

in a table there is a field number,lenofnum,sale1,sale2
if we insert 10 records in a table from number 0-to-9
and in sale1 and sale2 we insert value 10,000 and
lenofnum=1.
now we want some sort of convertion.
like for each of the ten numbers i want to convvert that
single number number into each possible combination of
its double number. like
number 0 would be conveterd into
00,01,02,03,04,05,06,07,08,09 and the lenofnumwillbecome
2 and sale1 and sale2 would be divided into 10 equal
segments.
similarly number 1,2.....9 will be break in the same
sequence. this was single to double convertion.
now double to tripple.
like 00 will be converted into 000,001,002...009 again in
ten sub divions
then tripplet to four.
major problem occurs from tripplet to four bcoz then
number of tripplets are 1000 and when the split into four
they become 10000 and it takes 1 min 30 secs.
i ve tried my level best to decrease the time below a
minute but not succeded.
i ve also tried sybalse sql anywhere 5.0 but that took
more than 1 1/2 mins.
so pleeeease suggest me someything
please email me the solution