Re: SQL express performens lagg

Well

if you read the prev. Threads then you would know that this SQL express is
only storing temp data, for 1 client app wich is running on it self...

as i also said b4 i have tryed other SQL servers with smaler footprint...
but thay wherer a lot slower ! by a LOOOt !!!

Whell the Hardware coment i will diregard...
i am a Software Dev that have a history and a deg. in tech Dev. so

But fore the fun of it i will explain...
whe app i am dev is an POS app and the hardware we are running on is the
fastes i could get my hans on if i dont want any Fans ! and i dont !
it is not god for the stability of the system,

Other info aboudt the system
Via Eden 700Mhz
512 Mb Ram
40 Gb SATA2 disk(7200Rpm)
Running Windows XPe Stripped down to fit the needs we have.
XPe image incl Express takes op 250Mb og the hdd and starts in aboudt 13 sec
in cleen boot from Power on.
the system dont seem to be using the processor mouch other then the 5 min i
asked aboudt.
my frees time acure after aboudt 18 Houers run time or so...(mostly when
thay forget to turn off the terminal at night)


Other then that i would hope that you dont coment if you dont use a proper
and a profesional langue, the Kiddy stuff you can save for when you get
Children !

Best Regrads
CEO of Dev
www.Posofcsandinavia.com



<aaron.kempf@xxxxxxxxx> skrev i en meddelelse
news:1161802670.987760.55900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Brian;

i've just got to say.. why would you skimp on a sql server like that?
IT SHOULD BE THE FASTEST MACHINE ON YOUR NETWORK

go to craigslist.. and buy a used dualie 1ghz for $100 any quit your
bitchin

-Aaron




Brian Bunin wrote:
In article <1161649352.607783.43720@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"aaron.kempf@xxxxxxxxx" <aaron.kempf@xxxxxxxxx> wrote:
you should write these values to a CSV and then BULK INSERT them.

I mean seriously here.

MUCH MUCH faster than writing a single record at a time then repeating


If you're going to be abusive, you can go play in the kiddie pool.
Particularly when you make inane statements without knowing the OP's
whole
situation.



.

Relevant Pages

  • Re: Access vs SQL
    ... from Access, tweaked my app a bit, and viola, everything works. ... MSDE 2000 adds a bit of complexity, but I have to say, compared to ... > (above and beyond what they pay for my engineering services). ... > Now, still using C1 components, I know I can upsize to MSDE or SQL ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQl Data Provider Performance Issues
    ... Can you provide a complete sample app ... selects with a single inner join perforn OK. ... When I run the query from SQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)
  • Re: from elsewhere, an assembler
    ... The code path is then just like a little bloated part of my own app. ... The way I think about it, the moment your app has its timeslice, this timeslice is yours until you call Sleepor by other means complete your processing. ... I dont know, but much likly it _cannot_ when you run at higher prority then the system. ... laugh nevertheless, laugh aginst all odds, and laugh about yourself.. ...
    (alt.lang.asm)
  • Re: Branch Office Deployment
    ... The question you are really asking goes beyond AD and SQL ... If this is a highly transactional environment where you would need ... We want the app to be available in the event the link ... What about replication? ...
    (microsoft.public.windows.server.active_directory)