Is that 300 character or 300k. The size of the record can effect the number of reads from the disk. Ie if the record exceed the bucket size read from the disk then you need to to do another read. There are parameters in setting the file size to handle record size, but I assume you are talking 300 characters and this should not be an issue.
By upgrading from Windows NT4 to Win2003 you could expect a doubling of the performance. With release 10.1 Select lists take advantage of hyperthreading, so having a CPU that process hyperthreading can improve performance. Areas that could also effect performance, other applications on the server especially if it is single CPU, fragmented disks, lack of Disk space on the drive with the swap area. This sounds more an issue outside of UniVerse and a result of the environment Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera Sent: Friday, 25 June 2004 11:04 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Performancing of File Universe Hello, The size of record is about 300, and the OS is Windows NT. Cisar. Thanks. -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de djordan Enviado el: viernes, 25 de junio de 2004 13:47 Para: [EMAIL PROTECTED] Asunto: RE: [U2] Performancing of File Universe What is the size of the records, what OS are you running on? David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera Sent: Friday, 25 June 2004 9:02 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Performancing of File Universe Hello, I creating the Index and the time for the SELECT, is down to 5 seconds, but I think that is very time. This is posible that the can is problem abouth memory bolcks or the server have chip memory (512 Mb RAM). Thanks. Cisar. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
