Subject | Error in sorting big queries |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-11-12T07:04:01Z |
Customer wrote:"Tried to get statement history in large data quantities
(db aprox 85 mb, period of 38 days and expected records - aprox 100000,
filter credit operations).
Maybe not enough swap space? (win2k, 188mb ram, 512 mb swap on two
logical disks, system disk space free 320 mb)"
He got error: 335544344: I/O error for file
"C:\winnt\temp\ib_sort_2341". Error while trying to write to file.
Device does not recognize the command.
and I/O error for file "C:\winnt\temp\ib_sort_2341". Database file not
found
What command can it be that device doesn't recognize? And how many free
space is needed?
Riho Ellermaa
(db aprox 85 mb, period of 38 days and expected records - aprox 100000,
filter credit operations).
Maybe not enough swap space? (win2k, 188mb ram, 512 mb swap on two
logical disks, system disk space free 320 mb)"
He got error: 335544344: I/O error for file
"C:\winnt\temp\ib_sort_2341". Error while trying to write to file.
Device does not recognize the command.
and I/O error for file "C:\winnt\temp\ib_sort_2341". Database file not
found
What command can it be that device doesn't recognize? And how many free
space is needed?
Riho Ellermaa