MySQL Generate unique identifier before insert -

-

i writing program logs packets of data mysql database.

the program forwards these packets , speed absolutely critical. want able forward these packets posible.

logging database done in background batch inserts of queued packets.

i don't want wait database write packets disc before forwarding them, need way of identifing individual packets.

how can this? basicaly need generate unique identifier each packet without using auto_increment have wait database then.

the unique thing individual packets time in came in, using time identifer seems bad idea (for example if time gets set backwards ntp/user/leapsecond/etc...)

is there way? can reserve unique identifers database without needing go disc?


Comments

Post a Comment

Popular posts from this blog

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

c# - Why won't my code write to SQL? -

-
i'm writing app store texts sql database, code throws exception saying "the variable name @par1 has been declared", i'm not sure how working , fixing if possible please =] offending code below private void smsgetter() { try { decodedshortmessage[] messages = comm.readmessages(phonemessagestatus.all, phonestoragetype.sim); sqlconnection conn = new sqlconnection("data source=*********;initial catalog=********;user id=**********;password=***********"); sqlcommand com = new sqlcommand(); com.connection = conn; conn.open(); foreach (decodedshortmessage message in messages) { //com.commandtext = ("insert smsarchives(message,blacklist) values ('" + message.data.userdatatext + "', 'yes')"); //com.executenonquery(); com.commandtext = (...
Read more

c# - Avoiding duplicate methods for Task and Task<T> -

-
i have logic task , task<t> . there way avoid duplicating code ? my current code following: public async task<socialnetworkuserinfo> getme() { return await wrapexception(() => new socialnetworkuserinfo()); } public async task authenticateasync() { await wrapexception(() => _facebook.authenticate()); } public async task<t> wrapexception<t>(func<task<t>> task) { try { return await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new socialnetworkexception("social network call failed", ex); } } public async task wrapexception(func<task> task) { try { await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new soci...
Read more